Oracle Database 10 g Release 2 New Features

Oracle Database 10 g Release 2 Ÿ Infrastructure Grid Ÿ High Availability Ÿ Security Ÿ Manageability Ÿ Data/Content Management Ÿ Application Development

Infrastructure Grid

Infrastructure Grid Application Server Clusters Real Application Clusters Automatic Storage Management

ASM Disk Groups Ÿ A pool of disks managed as a logical unit Disk Group

ASM Disk Groups Ÿ A pool of disks managed as a logical unit Ÿ Divides total disk space into uniform sized megabyte units Disk Group

ASM Disk Groups Ÿ A pool of disks managed as a logical unit Ÿ Divides total disk space into uniform sized megabyte units Ÿ ASM spreads each Oracle file evenly across all disks in a disk group Disk Group

Automatic Storage Management Ÿ Improved ease-of-use and configuration Ÿ Enhanced data provisioning Non-RAC database (10. 1) RAC database (10. 2) ASM (10. 1) CSS (10. 2) – Support transportablespaces Ÿ Enhanced storage virtualization – – Support multiple databases in a cluster Support databases at multiple release levels

ASM Performance Ÿ World record TPC-H 3 TB result of 59, 435. 7 Qph. H@3000 GB Ÿ Price performance ratio of $114. 00/Qph. H@3000 GB Ÿ Sun. Fire E 25 k with 72 1. 2 GHz Ultra. Sparc IV on Solaris 10, Oracle Database 10 g and Automatic Storage Management (ASM) Ÿ Jan 31, 2005

Data Provisioning London Ÿ Online Transportable Tablespace San Francisco Ÿ Full Database Transport Within Same Endian Platforms Ÿ Improved Oracle Streams Performance and Manageability Ÿ Tablespace Repository

Infrastructure Grid Application Server Clusters Real Application Clusters Automatic Storage Management

Real Application Clusters Ÿ Improved Robustness – – Cluster Verification Utility Improved OCR, Voting Disk resilience Ÿ Oracle Clusterware for integrated application availability Ÿ Load Balancing Advisory Ÿ Certified to 100 nodes Ÿ Improved performance ERP CRM DW

Oracle Clusterware Ÿ Provides unified framework for managing applications and database using the same HA infrastructure Apache Non RAC database listener database RAC db ORACLE_HOME ORA_CRS_HOME Microsoft IIS Custom Application ORACLE_HOME ORA_CRS_HOME

Extended FAN/FCF Client Integration Ÿ Oracle Call Interface – standalone, TAF, connection pool, and session pool connections are automatically broken and cleaned up by OCI and the application callback is invoked within seconds of the failure event. Ÿ ODP. NET – – FAN notifies ODP. NET which allows it to clean up resources from severed connections or establish new connections HA Events=true; on connection string Ÿ Service must have aq_ha_notifications=>true

RAC Load Balancing Advisory Ÿ Monitors workload activity for a service across all instances in the cluster Ÿ Analyzes the service level for each instance based on defined goal (service time or throughput) Ÿ Publishes FAN events describing the current service level, amount of work to be sent to each instance and data quality flag Ÿ If no goal defined, no load balancing events sent.

Runtime Connection Load Balancing with JDBC, ODP. NET CRM Client connection requests connection cache ? 60% “CRM is bored” 30% 10% “CRM is very busy” Instance 1 Instance 2 Instance 3 “CRM is busy”

Oracle Enterprise Manager Grid Control - RAC Enhancements Ÿ Interconnect Monitoring Ÿ Topology View Ÿ Automated Conversion of Single Instance to RAC Ÿ Automated Add/Delete Instance Ÿ Cloning of Oracle Home for Oracle Clusterware and RAC

"The clustered pool of storage managed by the ASM feature in Oracle Database 10 g Release 2 presents new key opportunities for Vanderbilt to improve storage utilization and save money through database storage consolidation in a single instance Oracle Database 10 g as well as Real Application Clusters (RAC) environments" - Darryl Boone MIS Director Vanderbilt University

High Availability

Oracle Secure Backup File Systems Linux, Unix Windows, Filers Ÿ Oracle Secure Backup is ideal for customers seeking a low cost alternative to complex backup products Ÿ Best integrated end-to-end backup of Oracle Databases – RMAN Oracle Backup Ÿ Backup Oracle Home, App Server and other file systems Ÿ Oracle Secure Backup includes: – – – Supports popular tape libraries & drives Media manger for RMAN backup and recovery of Oracle 9 i and 10 g databases to tape Fastest Database Backup on the market Centralized management of network backups Scalability to low 100’s of servers, 10’s of millions of files Easy management through Enterprise Manager

“We're definitely looking at the new backup for cost savings. We pay a lot of money for Legato licenses, and this seems comparable” - Aris Prassinos Distinguished Member of Technical Staff Motorola's Biometrics Business Unit http: //www. crn. com/sections/breakingnews. jhtml? article. Id=164900846

Fault Tolerant Standby Automatic Failover Production Database Synchronous Log Shipping Physical or Logical Standby DB Ÿ Fast-Start Failover implements automatic failover to a standby database – – Triggered by failure of Site, Hosts, Storage, or Network Works with and supplements RAC server failover Ÿ Failover occurs in seconds – Comparable to cluster failover Ÿ Original production site automatically rejoins the configuration after recovery

Fast Start Failover Ÿ Test Scenario – – 2 Intel servers, Red. Hat Linux, running 10. 2 beta 2 Simulated Workload 100 TPS, 100 Kb/s redo Scheduled Outage for switchover Unscheduled Outage less than 1 minute PRIMARY ACTIVE PRIMARY 30 secs <30 secs STANDBY ACTIVE STANDBY The Observer Wait for Failure Detection Automatic Failover <2 mins Restart Production Graceful Switchover Reinstates Production

“Airbus testing of Oracle Database 10 g Release 2 Data Guard Fast-start Failover produced impressive results. Failover executed automatically without manual intervention in less than a minute. This was much faster than a cold failover using third party cluster technology. ” - Werner Kawollek Application Management Operations Airbus Deutschland Gmb. H

“Data Guard's rolling upgrade capability is amazing. Airbus tested upgrading from Oracle Database 10 g Release 1 to release 2 using this feature. The elapsed time for the database upgrade was about 3 hours. But applications were available for all but less than 2 minutes while a Data Guard switchover was executed, quickly transitioning production from the previous database release to Oracle Database 10 g Release 2. ” - Werner Kawollek Application Management Operations Airbus Deutschland Gmb. H

Oracle Database 10 g Release 2 – Online Redefinition Enhancements Ÿ Online Redefinition supports – – – Online Move of a partitioned table AQ tables Clustered Tables Materialized View Logs Abstract Data Types (Objects)

Security

Transparent Data Encryption Application Ÿ Transparent Data Encryption ASO Network Encryption Data Decrypted Through SQL Interface Data Written To Disk Encrypted – – – Includes Key Management Transparent to applications Helps Address Privacy and Regulatory compliance Ÿ Store Username and Password in Wallet – Protect username and password on command line for batch jobs Ÿ Smart. Card integration for SSL Data Encrypted On Backup Files – Support existing certificates on smartcards

Manageability

Management and Monitoring

Self-managing Improvements Ÿ Enhanced Performance Self-Diagnostics – – – More powerful Automatic Database Diagnostic Monitor (ADDM) Current Activity Performance Analysis Automatic Workload Repository (AWR) Diff-Diff Reporting Ÿ Segment Advisor runs automatically during maintenance windows Ÿ Allow dropping of empty datafiles in tablespaces

Improved Database Control Ÿ New, Easier to Use Performance Screens Ÿ Support for Streams, AQ, XDB, and Spatial Ÿ SGA-attach mechanism for performance data – Enables analysis of slow or hung systems

Improved Grid Control Ÿ System Topology Viewer – – Model applications, clusters, storage Leveraged by all Grid Control subsystems Ÿ Services Dashboard – – Model business services Define and monitor SLA Ÿ Adaptive Alert Threshold

Improved Job Scheduler “Bulk Load” Job Oracle Database 10 g YES Do_bulk_load space? “New Data” Event Scheduler Rebuild_indx NO Recalc_stats Ÿ Chaining Ÿ Events Ÿ Customized Calendars Run Reports

“Oracle Database 10 g Release 2 offers significant new automations that make database management even easier. New features such as Automatic Segment Advisor and Dynamic Metric Baselines, to name a few, make my job considerably easier and allow me to focus more on strategic business IT issues and less on mundane day-to-day database management activities” - Vishal Anand Director of Database Systems Talk America

"Oracle Database 10 g Release 2 builds upon the manageability enhancements of its first release and now its administration is even simpler than before. It has introduced many new great features that will make the DBA’s job much easier, for novices and experts alike. " - Arup Nanda, Lead DBA Starwood Hotels

Data / Content Management

All Your Data Ÿ Ÿ Ÿ Complete Integrated Robust Scalable Secure Available on all platforms Ÿ Enhanced LOB performance Ÿ Online local partitioned text indexes Ÿ DICOM and JAI 1. 1. 2 Support Ÿ Improved performance of Network and Topology Models Ÿ Western Europe routing and geocoding Ÿ EPSG Coordinate Systems Ÿ Georaster Compression Ÿ Industry’s first XML Query Support

Native XML Query support in the Database User Ÿ XML Query is emerging as the consensus query language for XML Ÿ First mainstream commercial database release to support XML Query – Native = Fast, Efficient Ÿ Can mix-and-match XML Query and SQL in same query XML DB SQLX Expected W 3 C Recommendation in 2006 XML Query –

Improved Data Warehousing Ÿ Performance – – Up to 5 x improvement in sort performance Up to 3 x improvement in aggregate performance Ÿ Partitioning – – Increase maximum number of partitions per table from 64 k to 1024 K-1 Support ‘multidimensional’ partition-pruning Ÿ Analytics – – – Support standard linear algebra libraries within PL/SQL Enhancements to the SQL ‘model’ clause Decision trees in Oracle Data Mining Ÿ ETL – DML Error-logging

New in-Memory Sort Algorithm Ÿ New improved sort implementation – Hash-based implementation Ÿ Dramatic transparent performance improvements – – Fully leverages large amounts of memory Sort operation can be up to 5 times faster (*) Ÿ Improvements depending on sort characteristics – – – (*) Higher cardinality, more improvements Faster CPU, more improvements Select fewer columns, more improvements Total improvement depends on the weight of the sort in the overall operation

Application Development

HTML DB Release 1. 6 Ÿ Improved User Interface Ÿ Improved Documentation and Online Help Ÿ Master Detail Wizard Ÿ Charting Enhancements

Introducing: Project Columbus

Other Application Development Ÿ Client notification on table update Ÿ Linux ODBC Driver Ÿ JDBC 3. 0 support, connection load balancing, XA Connection Caching Ÿ SQL Regular Expressions - support for key Perl conventions Ÿ Unicode 4. 0 Support Ÿ PL/SQL Compilation Versioning

. Net Development Ÿ Visual Studio Integration (delivery via OTN) Ÿ Callout to Common Language Runtime Ÿ ODP. Net Fast Connection Failover

Oracle Database 10 g Release 2 Summary Ÿ Lowest Cost – – Oracle Backup Improved Sort Streams Performance Oracle Clusterware Ÿ Highest Quality of Service – – – Rolling Upgrades Fast-Start Failover Transparent Data Encryption Ÿ Easier to Manage ERP CRM DW

Q& A Q U E S T I O N S A N S W E R S