A Brief Look at Oracle Database 11g Penny Avril Principal Product Manager

1. A Brief Look at Oracle Database 11g Penny Avril Principal Product Manager Database, Server Technologies

2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remain at the sole discretion of Oracle.

3. Agenda • Recent Announcements • New Products Introduced this Year • Information Appliance Initiative • Information Lifecycle Management • Sneak Peek at Oracle Database 11g

4. What a year it has been – New Product Releases • Jan’06: Oracle Application Express • Feb’06: Oracle Database Express Edition • Mar’06: Oracle SQL Developer Secure Enterprise Search • Apr’06: Oracle Secure Backup • May’06 Oracle Warehouse Builder • Jul’06 Oracle Developer Tools for .NET • Aug’06 Oracle Content Database Oracle Records Database Oracle Database Vault

5. Oracle Database Vault • Compliance and protection from insiders select * from HR.emp DBA • HR DBA performs unauthorized actions during production create procedure… Fin Fin HR HR 3pm Monday • Multi-factor • authorization HR DBA HR Realm • Eliminates security risks from server consolidation FIN DBA Fin Realm released August 2006 • Database DBA views HR data • HR DBA views Fin. data

6. Coming ! Enterprise Audit Sources Customer Reports (custom) Oracle Database 9i R2 Partner Reports 3rd Party Audit Sources Oracle Audit Vault Reporting Audit Warehouse Oracle Database 10g R2 Enterprise Database Audit Settings Pre-defined Roles For Separation of Duty Oracle App Svr Oracle Applications Protected Schema Security Feature Oracle Database 10g R1 Data Mining Partitioning Project Audit Vault

7. Appliance Foundations Documented best-practice configurations for data warehousing For customers requiring flexibility and choice Benefits: High performance Simple to scale: modular building blocks Built on Oracle database and standard hardware Available today with HP, IBM, and EMC Information Appliances Scalable systems pre-installed and pre-configured: ready to run out-of-the-box For customers looking for the simplest, fastest solutions Benefits: High performance Simple to buy Fast to implement Built on Oracle database and standard hardware Available today with Panta Systems Further announcements in coming months Oracle Information Appliance Initiativemaking it easy to deliver DW systems

8. Information Appliance:Significant Cost Savings • An Oracle-based appliance delivers: • High performance out-of-the-box • Re-usable, general-purpose software and hardware • Leading support for the full breadth of applications • Enterprise-level security and availability • Leverages existing resources and expertise • Lower costs 1) Netezza, 2006 Whitepaper “How the Simplicity of the NPS Data Warehouse Appliance Lowers TCO”

9. Business Requirement – ILM (Information Lifecycle Management) • Reduce cost to retain data • Vast amounts of data are retained by enterprises for business and regulatory reasons • Need to optimize the cost of retaining data in the database to avoid skyrocketing costs Historical Data Active Data Less Active Data

10. Typical Database Implementation without ILM Data Lifecycle Less Active Active Historical Archive Tape Archive High Performance Storage Tier

11. Solution: Match Storage to Lifecycle Optimize Cost Data Lifecycle Offline Archive Less Active Historical Active Low Cost Storage Tier Online Archive Storage Tier Offline Archive High Performance Storage Tier

12. Database+ Partitioning The Oracle Database with Partitioning is Ideal for implementing ILM • Understands Business Data • Hardware Independent • Application Transparent • Fine Grained – Partitioning • Customizable • Central Point of Control • Low Cost – Use ASM to manage multiple storage tiers Less Active Historical Active Storage

13. ILM Assistanthelps manage the lifecycle of data

14. Oracle Database 10g Partition, Table Level Compression Range, List and Hash Partitioning Composite Partitioning Range List, Range Hash Oracle Database 11g adds Enhanced Table, Partition, LOB Compression NewInterval, Ref and Virtual Column Partitioning New Composite Partitioning Range Range, List Range, List List, List Hash Database Features for ILM

15. What is the next big challenge ? Change

16. Oracle Database 11g will focus on helping you preserve order amid change

17. Possible! KEY: Not to avoid Change but to minimize the instability Change is the only Constant • Enterprise production systems are complex • Actual workloads are difficult to simulate • Realistic testing before production is impossible • Change is the most common cause of instability • Reluctant to make changes • Unable to adopt new competitive technologies

18. New Change Assurance Capabilities in Oracle Database 11g Detect &TunePerformanceChanges PerformOnline Application Upgrades Capture &ReplayWorkload ManageExecutionPlanEvolution Set Up TestEnvironments PackageIncidentsforSupport OnlineHot Patching

19. Set up Test Environments using Snapshot Standbys • Convert Physical Standby to Snapshot Standby and open for writes by testing applications • ALTER DATABASE CONVERT TO SNAPSHOT STANDBY; • Discard testing writes and catch-up to primary by applying logs • ALTER DATABASE CONVERT TO PHYSICAL STANDBY; • Preserves zero data loss • But no real time query or fast failover • Similar to storage snapshots, but: • Provides DR at the same time • Single copy of storage Physical Standby Apply Logs Open Database Back out Changes Snapshot Standby Perform Testing Continuous Redo Shipping

20. Database Replay • Capture Workload in Production • Capture production workload with actual load & concurrency • Move the captured workload to test system • Replay Workload in Test • Make the desired changes in test system • Replay workload with production load & concurrency • Analyze & Report • Errors • Data divergence • Performance divergence • Use ADDM, AWR for further performance analysis

21. Client Client Client App Server App Server App Server Process Pre-Change Production System … Changes Unsupported Changes Supported Captured Workload • Database Upgrades, Patches • Schema, Parameters • RAC nodes, Interconnect • OS Platforms, OS Upgrades • CPU, Memory • Storage • Etc. Process Process … Capture Workload … Backup

22. Client Client Client … App Server App Server App Server Replay Driver Replay Driver Process Process Post-Change Test System Pre-Change Production System … … … … Processed Captured Workload Process Process Process Process … … Capture Workload … Backup Can use Snapshot Standby as test system

23. SQL Replay • Focus on impact of change on SQL query workload • Capture SQL in Production • Automatically capture SQL workload over a specified period • Capture SQL text, plans, bind variables, execution statistics • Can capture 10.2 SQL workload • Move captured SQL workload to test system • Replay SQL in Test • Replay SQL in pre and post-change configurations • Compare and analyze performance • For regressed SQL, use SQL Tuning Advisor (10g) to improve performance with SQL Profiles • Changes supported • Major & minor database releases, patches, parameters, schema, optimizer statistics, tuning recommendations

24. SQL Replay Performance Analysis

25. New Change Assurance Capabilities in Oracle Database 11g Detect &TunePerformanceChanges PerformOnline Application Upgrades Capture &ReplayWorkload ManageExecutionPlanEvolution Set Up TestEnvironments PackageIncidentsforSupport OnlineHot Patching

26. Online Application Upgrade • Large, mission critical applications are often unavailable for tens of hours while a patch or an upgrade is installed • Oracle Database 11g introduces revolutionary new capabilities that allow online application upgrade with uninterrupted availability of the application • The pre-upgrade application and the post-upgrade application can be used at the same time • End-user sessions therefore enjoy hot rollover

27. Online Application Upgrade The challenge • The installation of the upgrade into the production database must not perturb live users of thepre-upgrade application • The changes must be made in privacy • Transactions done by the users of the pre-upgrade application must by reflected in the post-upgrade application • For hot rollover, we also need the reverse of this: • Transactions done by the users of the post-upgrade application must by reflected in the pre-upgrade application

28. Online Application Upgrade How did we do it? • Evolutionary capability improvements • Some table DDLs that used to fail if another session had outstanding DML now always succeed • Others, that cannot succeed while there’s outstanding DML, are now governed by a timeout parameter • Online index creation and rebuild now never wait • The dependency model is now fine-grained:e.g. adding a new column to a table, or a new subprogram to a package spec, no longer invalidates the dependants

29. Online Application Upgrade Revolutionary new capabilities • 11.1 brings the edition, the editioning view, and the crossedition trigger • Code changes are installed in the privacy of a new edition. • Data changes are made safely by writing only to new columns or new tables not seen by the old edition • An editioning view exposes a different projection of a table into each edition to allow each to see just its own columns • A crossedition trigger propagates data changes made by the old edition into the new edition’s columns, or (in hot-rollover) vice-versa

30. New Change Assurance Capabilities in Oracle Database 11g Detect &TunePerformanceChanges PerformOnline Application Upgrades Capture &ReplayWorkload ManageExecutionPlanEvolution Set Up TestEnvironments PackageIncidentsforSupport OnlineHot Patching

31. SQL Plan Managementcontrolled plan evolution Business Requirement • Data is changing over time • Statistics and execution plans become suboptimal • Statistics have to be updated • Possibly unpredictable changes of execution plans • Today you have ‘freeze’ critical plans or statistics • Solution • Optimizer automatically manages SQL Plan Baselines • Only known and verified plans are used • Plan changes are automatically verified in maintenance window • Only comparable or better plans are used going forward • Can pre-seed critical SQL with baselines from SQL Replay

32. Automatic Diagnostic WorkflowReduce Time to Problem Resolution Automatic Diagnostic Repository Critical Error 2 3 1 • Alert DBA • Targeted assessments • Assisted SR Filing Auto Bug Matching (post 11gR1) • Incident Packaging Service • First-failure Capture No Duplicate Bug? Yes 4 5 EM Support Workbench: • Package Incident information including CCR info • Guided Repair EM Support Workbench: • Apply Patch or Workaround • Guided Repair

33. Incident Packaging Service

34. Feature-Based Patching Recommended interim patch becomes available in Metalink Database targets/groups • Automatic correlation against feature usages eliminates unnecessary downtime • Both ad-hoc searches and subscription supported 1 2 Proactively push metadata (version, feature relevance) for evaluation 5 Features & versions collected Apply patch 3 Customer Relevant Patch Found? Grid/DB Control Yes 4 Download patch

35. Online Patching of One-off Patches • Oracle already supports rolling patches between nodes in a cluster • The next major release adds online patching of a running Oracle executable (single instance or cluster) with no downtime • Integrated with OPatch • Many one-off patches can be hot patched • Great for diagnostic patches • Initially available on Linux and Solaris • Long term goal is online patching of Critical Patch Updates (CPUs).

36. Manageability, High Availability and Performance Highlights

37. High-Load SQL AWR Automatic SQL Tuning PackagedApps Customizable Apps • Automatically chooses high-load SQL based on response time, throughput and frequency criteria • Automatically tunes SQL by creating SQL Profiles • Automatically test executes the tuned plans to verify improvement • Automatically implements greatly (3X) improved plans (optional) • Automatically reports missing access structures, stale stats, poorly structured SQL • Automatically runs during maintenance window or manually triggered Nightly Automatic SQL Tuning SQL Profiling Index, Stats, Structure Analysis SQL Profiles Test Execute Implement Automatic Advisor Report Manual Well-tuned SQL

38. Partition Advice from Access Advisor Provide advice on Partitioning methods Partitioning advice for tables,indexes, MVs Consider entire query & DML workload to improve query performance Integrated, non-conflicting advice with Indexes, MVs Automatic Interval Partition Creation On first insert With constant width intervals for dates and numbers Existing RANGE partitioned tables can be converted to INTERVAL RANGE and INTERVAL can coexist in a single table Index, MV Analysis Partition Management Made Easy PackagedApps Customizable Apps SQL Workload Access Advisor Partition Analysis Partition Advice Index, MV Advice Well-Designed Schema

39. Flashback Data Archive Select * from orders AS OF ‘Midnight 31-Dec-2004’ • Long term retention - years • Automatically stores all changes to selected tables in Flashback Data Archive • Archive cannot be modified • Old data purged per retention policy • View table contents as of any time using Flashback SQL • Uses • Change Tracking • ILM • Long term history • Auditing • Compliance ORDERS Archive Tables Changes User Tablespaces Flashback Data Archive Oracle Database Total Recall

40. Physical Standby with Real-Time Query Real-time Queries Concurrent Real-Time Query • Read-only queries on physical standby concurrent with redo apply • Supports RAC on primary / standby • Queries see transactionally consistent results • Immediate appeal to the many users of physical standby • DR with real time query is unique in the industry – no idle resources • Handles all data types, but not as flexible as logical standby Continuous Redo Shipment and Apply Primary Database Physical Standby Database

41. PerformanceMajor New Performance Innovations • Automatic “native” PL/SQL and Java compilation • Now fully transparent, no C compiler required • SecureFiles • New generation LOBs just as fast as files • Query Results caches • Fast caching of query/function results for read-mostly data • Table Compression • Now for OLTP as well as DW applications • And much more … • RAC optimizations, TimesTen enhancements, faster triggers, Auto NFS, faster upgrades, faster Streams, faster Data Guard, …

42. Oracle SecureFilesUnified Storage • SecureFiles is a new database feature designed to break the performance barrier keeping file data out of databases • Similar to LOBs but much faster, and with more capabilities • Transparent encryption, compression, deduplication, etc. • Preserves the security, reliability, and scalability of database • Superset of LOB interfaces allows easy migration from LOBs • Enables consolidation of file data with associated relational data • Single security model • Single view of data • Single management of data

43. Q2: Use it transparently Q1: build query cache GBY GBY GBY GBY GBY GBY join join join join join join join join join join join join join T2 T6 T1 T5 T3 T4 T4 T2 T5 T1 T1 T2 T3 T6 T3 cache Server Results Cachetaking the buffer cache to the next level • Automatically Caches results of queries, query blocks, or pl/sql function calls • Cache is shared across statements and sessions on server • Significant speed up for read-only / read-mostly data

44. Consistent Caching Application Server Database OCI Consistent Client Cachelike cache fusion between server and client • Caches query results on client • Improves performance for read-mostly tables • Faster response time - eliminates network round trips • Saves server CPU • Consistent with server • Cache proactively refreshed when result set changes • Maximum age of consistency info can be set

45. Compression for OLTP • Oracle Database 9i table compression works for DW • Compression for bulk load operations • Direct Path Load • Create Table Select As … • Compression is now viable for OLTP • Regular (non-bulk) INSERT, UPDATE, DELETE • Add, Drop Column • Compression benefits • Reduced disk space consumption – typically 2x to 3x • Reduced IO • Enhanced cache efficiency • Better read performance

46. Oracle Content and Records DBContent Management XML DBIntegrated Native XML Database Oracle TextText Indexing and Search Oracle Locator & SpatialLocation and Proximity Searching Oracle interMediaMultimedia management RelationalCharacters, Numbers, Dates, LOBs Information Management Platform • Complete • Integrated • Robust • Scalable • Secure • Available on all platforms

47. Information Management • Complete • Integrated • Robust • Scalable • Secure • Available on all platforms Oracle Content and Records DB11g Feature Refresh XML DBBinary XML, Schema Evolution Information RetrievalText Improvements, Semantic Processing Oracle Locator & SpatialImproved maps, 3D support, traffic updates Oracle interMediaDICOM Medical Image support RelationalSecure Files

48. High Availability Logminer, Physical Standby, Streams support for XMLType, TDE Fast Start Failover with Async Propagation Faster Logical Standby Apply Flashback Transaction Data Repair Advisor Integration Faster Gateways Gateways to Legacy Databases Streams Synchronous Capture Streams Faster Apply Performance and Scalability RAC Scalability Enhancements Faster PL/SQL Triggers Security Tablespace and LOB Encryption Secure By Default Enterprise Manager support for TDE, OLS, VPD, EUS TDE works with LOBS, log miner Windows VSS Writer for Point In Time Copies Manageability and Diagnosability Unified Automatic Memory Management Scheduler supports remote jobs Automatic Health Monitoring Faster Database Upgrades ASM Variable extent sizes, Fast resync, Preferred reads RAC Highly optimized protocols ADDM for RAC Content Management Infrastructure Binary XML storage Enhanced XML indexing Combined Text and Relational Indexes DICOM Medical Imaging Support Storage & Query of Semantic Content (RDF, OWL) Business Intelligence Next generation OLAP Supermodels for Data Mining Enterprise Manager is DW aware PIVOT/UNPIVOT operators Some other Oracle Database 11g Highlights

49. The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remain at the sole discretion of Oracle.

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