Oracle9i Release 2

New Features

Peter SechserSenior Principal ConsultantOracle Corporation

Application Development

• XDB - High-performance XML storage and retrieval

• Open server-side PL/SQL and Java debugging

• Globalization - Unicode 3.1 Support

• JDK 1.3 Support• PL/SQL, C and C++ Improvements

• XDB - High-performance XML storage and retrieval

• Open server-side PL/SQL and Java debugging

• Globalization - Unicode 3.1 Support

• JDK 1.3 Support• PL/SQL, C and C++ Improvements

Provide the most complete platform for developing applications

Availability

• Logical Standby -Availability you can use

• Improvements in Oracle Data Guard

• Speed up of Application and Database Upgrades

• Flashback Query Improvements

• Logical Standby -Availability you can use

• Improvements in Oracle Data Guard

• Speed up of Application and Database Upgrades

• Flashback Query Improvements

Achieving Continuous Data AvailabilityAchieving Continuous Data Availability

Logical Standby - Availability you can use

ProductionProductionDatabaseDatabase

Continuously OpenContinuously OpenStandby DatabaseStandby Database

Synchronous orSynchronous orAsynchronousAsynchronous

shipping of shipping of Redo LogsRedo Logs

OptionalOptionalDelayDelay

Transform toTransform toSQL and ApplySQL and Apply

Additional IndexesAdditional Indexesand Materialized Viewsand Materialized Views

AllowedAllowed

Oracle Data Guard Oracle Data Guard Broker managesBroker manages

environmentenvironment

Graceful Switchover/SwitchbackGraceful Switchover/Switchbackand Failoverand Failover

Logical Standby - Protection against all datacenter disasters

Data Protection Capability Oracle Microsoft IBMData Protection CapabilityData Protection Capability OracleOracle MicrosoftMicrosoft IBMIBM

Log based capture of changes

Resilient to data corruptions

Failover site available for reporting

Protection from human error

Failover site available for backups

DDL changes supported

Failover to local or remote site

Zero data loss capability

GUI based turn-key management

Log based capture of changesLog based capture of changes

Resilient to data corruptionsResilient to data corruptions

Failover site available for reportingFailover site available for reporting

Protection from human errorProtection from human error

Failover site available for backupsFailover site available for backups

DDL changes supportedDDL changes supported

Failover to local or remote site Failover to local or remote site

Zero data loss capabilityZero data loss capability

GUI based turnGUI based turn--key managementkey management

Yes

Yes

Yes

Yes

Yes

YesYes

Yes

Yes

YesYes

YesYes

YesYes

YesYes

YesYes

YesYesYesYes

YesYes

YesYes

Yes

Yes

Yes

Yes

No

NoNo

No

No

YesYes

YesYes

YesYes

YesYes

NoNo

NoNoNoNo

NoNo

NoNo

Yes

Yes

Yes

Yes

No

NoNo

No

No

YesYes

YesYes

YesYes

YesYes

NoNo

NoNoNoNo

NoNo

NoNo

• Reporting Database • Protection from single failure• No data loss fast failover

• Synchronous Transport over a dedicated 1GB LAN/Fiber Link

• Maximum Availability ModeAnn ArborAnn ArborPrimaryPrimaryDatabaseDatabase

Ann ArborAnn ArborRemoteRemoteLogicalLogicalStandbyStandby

Proquest - Information and LearningOracle9i Data Guard Architecture

Improvements in Oracle Data Guard

� Standby Features– Data Guard Broker automation– Better network glitch handling– Support for multiple synchronous

standbys– Handles missing or corrupt logs

(detect and resend)– Disallow unlogged operations on

primary that will invalidate standby

� Logminer Features– Support for LOBs, Longs

and Parallel DML– Multi-versioned dictionary– Real Time mining of online

logs

Speed up of Application and Database Upgrades

� Rename Constraint� Rename Column� Significantly reduced PL/SQL recompilation

– Fast loading of wrapped source (multiple lines per row)

– Do nothing on load of unchanged package, view or synonym

– Remove double invalidations– Parallel compilation in dependency order

Flashback Query Improvements

� Full SQL support for flashback query

– Flashback within SQL statement instead of session� Restore deleted rows� Restore old values� Restore previous version of

table� Select difference between

two times– Flashback retention for LOBs

Information Sharing

•Oracle Streams - Integrated infrastructure for all information sharing requirements

•Oracle Streams - Integrated infrastructure for all information sharing requirements

Share all of your business informationmore effectively

Oracle Streams - Integrated infrastructure for all information sharing requirements

Intelligent, Unified, Intelligent, Unified, Time OrderedTime Ordered

Information StreamInformation Stream

DataDataChangesChanges

DatabaseDatabaseEventsEvents

ApplicationApplicationMessagesMessages

ReportingReportingReplicasReplicas

UpdateableUpdateableReplicasReplicas

MessagingMessagingApplicationsApplications

Rules based Publish/Subscribe

Propagation

InstreamTransformations

DataDataWarehouses andWarehouses and

Data MartsData Marts

Directed andSubset

InformationStreams

Oracle Streams - Integrated infrastructure for all information sharing requirements

� Replication Advantages– Log based capture means less

system and network overhead– No quiesce required for DDL

changes – Replicate with non Oracle

systems – Replicated information may be

transformed – Different systems can receive

different subsets of data

� Messaging Advantages– Messages can be database

changes or explicit application events

– Low cost and automatic capture and application of events and messages

– Single queue for all message and event payloads

– Gateways to other messaging systems

Oracle Streams - Integrated infrastructure for all information sharing requirements

� Data Warehouse Advantages– Low overhead on source system – No security access required to source system– Automatically captures changes– Automatically transform data – Automatically load staging area or operational

data store– Supports ‘trickle feeds’ for near real time

reporting

Hidden Slide for Notes

Manageability

Management made EASY

• Eliminate, Automate, Simplify

• Built-in intelligent advisories and tuning features

• Automate routine administration

• Oracle Enterprise Manager enhancements

• Eliminate, Automate, Simplify

• Built-in intelligent advisories and tuning features

• Automate routine administration

• Oracle Enterprise Manager enhancements

Oracle Enterprise Manager Enhancements and Improvements

� Schema management– clone subset of production environment (data

and statistics) for development testing� Support for new Release 2 features

– XML, Oracle Streams, Logical Standby, new database advisors, locally managed SYSTEM tablespace (DBCA)

� Support for Release 1 features– Resumable statements, resource management

control operations

Business Intelligence

• New Partitioning capabilities

• Additional Data Mining Operations

• Improved OLAP integration

• New Partitioning capabilities

• Additional Data Mining Operations

• Improved OLAP integration

Scalable, internet-ready business intelligence platform

Enhanced VLDB management with Composite Range List Partitioning

JANJAN

FEBFEB

OCTOCT

NOVNOV

DECDEC

� Range partition data for ease of rolling window data loads i.e by month

� Sub partition by value for other data management requirements - i.e maintenance/backup by region

EastEast WestWest NorthNorth SouthSouth CentralCentral

Business Intelligence

� Complete OLAP Services

– Integrate OLAP Services fully in the database and make it more competitive in computational power and space usage.

� Features– Complete OLAP

Services Integrated RDBMS architecture

– Data compression– Skip stream/lob– Union-All rewrite of

Queries with Grouping Sets

Scalability and Performance

• Cluster File System for Windows and Linux

• Portable Clusterware -Oracle RACGuard Version 2

• Performance Improvements

• Cluster File System for Windows and Linux

• Portable Clusterware -Oracle RACGuard Version 2

• Performance Improvements

Support millions of users for lowest cost

Real Application Cluster Filesystem for Windows and Linux

� Storage management same as single node

� Simplified Backup/restore– Remove NFS dependency

Portable Clusterware - Oracle RACGuard Version 2

� Seamless integration of Oracle9i Real Application Clusters with Clusterware

– Single system image for workload groups across RAC

– Packaged install, configuration, boot and restart � for database, instances, listeners, enterprise

agents, cluster addresses via DBCA, NetCA, SRVCTL

– Automated boot, failover, and restore of work groups via Oracle cluster-ware

Performance Improvements� Optimize Library cache latch and

lock acquisition� Optimize Row cache object latch� Support Multiple DLM receivers for

parallelism� Reduce DLM context switch and

CPU consumption� Reduce CR block cleanout cost� Multi-lock and block get for Insert� Adaptive locking(asyn multi-lock

open) for read mostly data� Improve SMON second pass

recovery

� Improve bitmap segment space management to be on par with Free List

� Reduce Btree leaf page split cost

� Reduce Fusion Messaging cost(messaging vectoring, OSD optimization)

� Improve Index Only Table support

� Message-less lock open in S mode

Security and Directory

• Oracle Label Security improvements

• VPD improvements• Improve security

management• Meet new security

requirements

• Oracle Label Security improvements

• VPD improvements• Improve security

management• Meet new security

requirements

Support End-to-End Security Infrastructure for Millions of Users

Security and Directory

� DBA grant/revoke privileges on other user's objects � Virtual Private Database support for table/view

synonyms� Specify username/password on CREATE

DATABASE � Provide accountability of SYS/SYSDBA operations� SSL integration with Hardware accelerator cards� Inverse group support (a.k.a. Releasabilities) in

Oracle Label Security

Windows Integration

• Support for IA64 platforms

• Improved Windows Data Access support

• Oracle Failsafe Improvements

• Support for IA64 platforms

• Improved Windows Data Access support

• Oracle Failsafe Improvements

Lead platform of choice for organizations deploying on Windows 2000

Support for IA64 platforms

� 64-bit Database port for Windows

� 64-bit Database port for Linux

� 64-bit OLE DB Provider

� 64-bit Oracle ODBC Driver

� 64-bit Oracle Services for MTS

Improved Windows Data Access support

� OLEDB.Net compliance and performance improvements

– Performance� Reduce numbers of round trips to database� Cache metadata information for a query

� ODBC.Net compliance

Oracle Failsafe Improvements

� Support for 64 bit Windows� Support for physical and

logical standby.– monitoring of primary and

standby databases

� Multi-cluster support– clusters or groups can be

managed as collections– policies can be applied across

clusters

� Support for Windows .Net server

Q U E S T I O N SQ U E S T I O N SA N S W E R SA N S W E R S