Oracle Database 10g Release 2

1. Oracle Database 10g Release 2 New Features

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

3. Infrastructure Grid

4. Infrastructure Grid Application Server Clusters Real Application Clusters Automatic Storage Management

5. Infrastructure Grid Application Server Clusters Real Application Clusters Automatic Storage Management

6. ASM Disk Groups • A pool of disks managed as a logical unit Disk Group

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

8. 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

9. Automatic Storage Management • Improved ease-of-use and configuration • Enhanced data provisioning • Support transportable tablespaces • Enhanced storage virtualization • Support multiple databases in a cluster • Support databases at multiple release levels Non-RAC database (10.1) RAC database (10.2) RAC database (10.2) RAC database (10.2) ASM (10.1) ASM (10.1) ASM (10.1) CSS (10.2) CSS (10.2) CSS (10.2)

10. ASM Performance • World record TPC-H 3TB result of 59,435.7 QphH@3000GB • Price performance ratio of $114.00/QphH@3000GB • SunFire E25k with 72 1.2GHz UltraSparc IV on Solaris 10, Oracle Database 10g and Automatic Storage Management (ASM) • Jan 31, 2005

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

12. Infrastructure Grid Application Server Clusters Real Application Clusters Automatic Storage Management

13. 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

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

15. 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

16. 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.

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

18. 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

19. "The clustered pool of storage managed by the ASM feature in Oracle Database 10g 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 10g as well as Real Application Clusters (RAC) environments" • Darryl Boone • MIS Director • Vanderbilt University

20. High Availability

21. Oracle Secure Backup File Systems • 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 • Media manger for RMAN backup and recovery of Oracle9i and 10g databases to tape • Fastest Database Backup on the market • Backup Oracle Home, App Server and other file systems • Oracle Secure Backup includes: • Centralized management of network backups • Scalability to low 100’s of servers, 10’s of millions of files • Easy management through Enterprise Manager Linux, Unix Windows, Filers Databases RMAN Oracle Backup Supports popular tape libraries & drives

22. “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/breakingnews.jhtml?articleId=164900846

23. 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 Fault Tolerant Standby Automatic Failover Physical or Logical Standby DB Production Database Synchronous Log Shipping

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

25. “Airbus testing of Oracle Database 10g 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 GmbH

26. “Data Guard's rolling upgrade capability is amazing. Airbus tested upgrading from Oracle Database 10g 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 10g Release 2.” • Werner Kawollek • Application Management Operations • Airbus Deutschland GmbH

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

28. Security

29. Transparent Data Encryption Application • Transparent Data Encryption • 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 • SmartCard integration for SSL • Support existing certificates on smartcards ASO Network Encryption Data Decrypted Through SQL Interface Data Written To Disk Encrypted Data Encrypted On Backup Files

30. Manageability

31. Management and Monitoring

32. 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

33. 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

34. 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 Grid Control

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

36. “Oracle Database 10g 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 AnandDirector of Database Systems • Talk America

37. "Oracle Database 10g 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

38. Data / ContentManagement

39. 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 All Your Data

40. Native XML Query support in the Database User • XML Query is emerging as the consensus query language for XML • Expected W3C Recommendation in 2006 • First mainstream commercial database release to support XML Query • Native = Fast, Efficient • Can mix-and-match XML Query and SQL in same query XMLQuery SQLX XML DB

41. Improved Data Warehousing • Performance • Up to 5x improvement in sort performance • Up to 3x improvement in aggregate performance • Partitioning • Increase maximum number of partitions per table from 64k to 1024K-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

42. 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

43. ApplicationDevelopment

44. Improved User Interface • Improved Documentation and Online Help • Master Detail Wizard • Improved User Interface • Improved Documentation and Online Help • Master Detail Wizard • Charting Enhancements HTML DB Release 1.6 • Improved User Interface • Improved User Interface • Improved Documentation and Online Help

45. Introducing: Project Columbus

46. 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

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

48. ERP CRM DW Oracle Database 10g 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

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