1 / 56

Oracle Database 11g Overview

Oracle Database 11g Overview. Gary Quarles Sales Consultant. Oracle Database 11g. Major new release of Oracle functionality In Beta since September 2006 Production expected in 2007 Furthers the adoption of Grid Computing Benefits Unique scale-out technology with single database image

ryo
Télécharger la présentation

Oracle Database 11g Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Database 11g Overview Gary Quarles Sales Consultant

  2. Oracle Database 11g • Major new release of Oracle functionality • In Beta since September 2006 • Production expected in 2007 • Furthers the adoption of Grid Computing • Benefits • Unique scale-out technology with single database image • Lowers server and storage costs • Increases availability and scalability • Disruptive technology • Changes the game for the database industry • Changes the way data centers look and operate • Currently in rapid adoption phase

  3. SMPDominance Grids oflow costhardware andstorage Sustained Innovation – Grid Computing RACClustersforAvailability

  4. RAC 8+ node customers Citigroup Burlington Coat Factory J2 Global Communications Genworth Financial Amazon.com MSDS Mercado Libre Yahoo! Overture Babcock Engineering Ordnance Survey Dell Yahoo! SAIC Fairmont Hotels ADESLAS Evite.com Quelle AG Telstra Gas Natural MyTravel Thompson AOL Vivo Sagawa Kyubin Well Proven Scalability

  5. Example: Amazon Data Warehouse 16 Node RAC Linux Cluster 4 CPUs per Node • 51 TB row data • 71 TB of disk space • RAC and ASM • Pure Scale-Out architecture • Both server and storage layer • In top ten largest Warehouses in Winter Survey • 50x growth in data in 6 years • More than doubled in last year 8 SAN switches, 32 port each Switch Switch Switch 84 HP MSA-1000 Arrays

  6. Benefits Achieved • Scalability - Easily Expanded Original 10 Node Cluster to 18 Nodes • Improved Availability • Disaster Tolerance with Dataguard • Better Performance - Large Queries – 50% Faster • Easier, Less Disruptive Storage Changes with ASM • Significant Cost Savings, Better IT Productivity Data Center 2 18-node cluster IBM x-Series Oracle RAC 10gR2 IBM xSeries – SUSE Linux Data Center 1 Standby for SKU 5-8 DBs Standby for SKU 1-4 DBs SKU 6 DB SKU 3 DB SKU 1 DB SKU 5 DB SKU 4 DB SKU 8 DB SKU 2 DB SKU 7 DB Oracle ASM – Two diskgroups, one SAN, one SATA Dataguard

  7. Mark Beyer, GartnerDecember 2006 “Oracle customers are highly satisfied with its Real Application Clusters and Automatic Storage Management when pursuing scale-out strategies.”

  8. Business and Technology Status 2007 • Global economy is more dependent on IT than ever before • Information management is THE major mission of the enterprise • Organizations are being pushed to ADAPT quickly to change • Economic, Technologic, Regulatory • “At least two-thirds of all IT spending is just to sustain the business, not to change or transform the business.” - Gartner Group

  9. Oracle Database11g Big Message • Increases business and IT agility and lowers overall costs! • Enables change to happen while maintaining stability! • Takes management and diagnostic automation to the next level! • Freeing key personal for higher value tasks! • Simplifies your information infrastructure! • Provides the least expensive, most scalable, secure and highly available information management and rapid application development environment!

  10. Make Change Safe Enabling Change While Maintaining Stability

  11. Barriers to Change • Proactive testing of upgrades is time consuming, costly, and often not as effective as needed • Upgrades still risk disruption of production systems • Many upgrades still require significant downtime • Still have to endure potentially long period of instability as bugs are found and fixed • DBAs are asked to do too much to help, e.g., diagnostic patches that require more downtime • Software vendors take too long to fix bugs

  12. Database Replay

  13. The Need for Database Replay • Businesses want to adopt new technology that adds value • Extensive testing and validation is expensive in time and cost • Despite expensive testing success rate low • Many issues go undetected • System availability and performance negatively impacted • Cause of low success rate • Current tools provide inadequate testing • Simulate synthetic workload instead of replaying actual production workload • Provide partial workflow coverage Database Replay makes real-world testing possible

  14. Analysis & Reporting Database Replay • Replay actual production database workload in test environment • Identify, analyze and fix potential instabilities before making changes to production • Capture Workload in Production • Capture full production workload with real load, timing & concurrency characteristics • Move the captured workload to test system • Replay Workload in Test • Make the desired changes in test system • Replay workload with full production characteristics • Honor commit ordering • Analyze & Report • Errors • Data divergence • Performance divergence

  15. Client Client Client … Database Replay: Supported Changes Changes Unsupported MiddleTier Changes Supported • Database Upgrades, Patches • Schema, Parameters • RAC nodes, Interconnect • OS Platforms, OS Upgrades • CPU, Memory • Storage • Etc. Recording of External Client Requests Storage

  16. Comparison of LoadRunner & DB ReplayTesting e-Business Suite 80 24 20 20 5 4 2 5 0 0 Total Testing Time • DB Replay: 2 weeks • LoadRunner: 30 weeks

  17. 150 Days 10 Days Why DB Replay? From: To: Production workloads Artificial workloads Complete workflows Partial workflows Days of development Months of development Automated Manual intensive Low risk High risk

  18. … Database Replay Workflow Production (10.2.0.4) Test (11.1) Clients Replay Driver Mid-Tier … Storage Storage Process Replay Analysis & Reporting Capture

  19. Make Change Safe • Major online upgrade enhancements • Online database upgrades for Data Guard Physical Standby • Physical Standby is Data Guard’s high performance disaster recovery solution • Uses new Transient Logical Standby feature for online upgrades • Online Database Patching • For most one-off patches including diagnostic patches

  20. Automate Still More Administrative Functions Freeing key personal for higher value tasks!

  21. Why Automate? • Free key personal for higher value tasks! • Increased DBA productivity • Reduce risk of DBA errors • Dramatically increase the QOS DBAs deliver • More proactive management and planning • Continual optimized performance • Higher availability

  22. Long Term Project • Goal: Automate all administrative functions • Over three releases • Begun in Oracle9i • Major focus in Oracle Database 10g • Continued major focus in Oracle Database 11g • Three step process • Instrumentation – lays measurement infrastructure • Advisory – monitors the administrative function, identifies sub-optimal behaviors, alerts DBA to problems, and advises on corrective actions • Automation – gives DBAs the option to turn on full automation

  23. Self Managing Database Auto-Tuning Advisory Storage Backup Memory Apps/SQL Schema RAC Recovery Replication Instrumentation

  24. Self Managing Database Auto-Tuning Advisory Storage Backup Memory Apps/SQL Schema RAC Recovery Replication Instrumentation

  25. Database-Level ADDM 11g Self-Diagnostic Engine Instance-Level ADDM Inst 2 Inst 3 AWR 2 AWR 3 AWR 1 ADDM for RAC • Automatic Database Diagnostics Managers (ADDM) for Real Applications Cluster (RAC) • RAC expert in a box • Identifies performance problems for the entire RAC cluster database • Database-wide analysis of: • Global cache interconnect issues • Global resource contention, e.g. IO bandwidth, hot blocks • Globally high-load SQL • Skew in instance response times Inst 1

  26. Auto Capture High-Load SQL Automatic SQL Tuning • Automatically captures high-load SQL • Automatically tunes SQL by creating SQL Profiles • Automatically implements (optional) greatly improved SQL plans • Automatically reports analysis • Automatically runs during maintenance window PackagedApps Custom Apps Nightly Automatic SQL Tuning • SQL Profiles • SQL Analysis Automatic implement Report Manually implement Well-tuned SQL

  27. New! Partition Analysis Partition Advice PartitioningAdvisor PackagedApps Custom Apps • Considers entire query workload to improve query performance • Advises on partitioning methods • Range (equal-interval), range key and interval • Hash, hash key • Integrated, non-conflicting advice with Indexes, MVs SQL Workload SQL Advisor SQL Plan Tuning Access Analysis SQLStructure Analysis SQLProfile SQLAdvice Indexes& MVs Well-tuned SQL & Schema

  28. Automatic Memory Tuning • Automatically adapts to workload changes • Maximize memory utilization • Single dynamic memory parameter • Helps eliminate out-of-memory errors OS Memory OS Memory DB Shared Memory DB Shared Memory DB Process Memory DB Process Memory

  29. Simplify Systems Simplify Your Information Infrastructure For Maximum Agility and Lowest Cost!

  30. DSS DSS Standby HR Standby HR Finance Finance Standby Old Pre-Grid Infrastructure

  31. The Cost of Same Old Approach • Poor Resource Utilization • Built for peak periods • Gartner estimates average server utilization rate at 5-10%! • Standby hardware and software costs virtually double the investment and further reduce useful utilization • Management happens in silos • Uneven process maturity across managed silos • Availability, security, performance • Increased staff • Proliferation of tools that have overlapping capabilities • Software patching/testing, upgrade tasks are multiplied • Increases information complexity and lowers agility • More data movement required (i.e. increased latency, increased storage, increased integrity issues)

  32. HR Financials DSS Oracle Database 10g Database Grid Consolidate Workloads to a Single…

  33. Oracle Database 10g Storage Grid HR Financials DSS Automatic Storage Management Low Cost Module Storage Monolithic Storage

  34. Oracle Database 11g Data Guard • Fundamentally changes the value of redundant infrastructure • Can now use Physical Standby for: • Reporting • Read only Physical Standby • Online Upgrades • Transient Logical Standby • Testing • Snapshot Stanby • Backups • Fast incremental backups • Major performance enhancements too

  35. Oracle Database 11g SecureFiles • SecureFiles • Eliminates need for file systems • Just as fast as file systems with all the capabilities of the Oracle Database • Store all your data in the database with one consistent: • Security and auditing model • Backup & recovery mechanism • Storage management mechanism (ASM) • Transaction and concurrency model • Interface and protocol • Value added services like encryption, compression, and de-duplication

  36. Oracle Database 11g Partitioning • Major New Partitioning Enhancements • One consistent way to manage all your data • Not just for data warehouse and high-end OLTP any more • New referential, virtual column, composite, and interval partitioning features bring partitioning to mainstream • Easier management of today’s rapidly growing datasets • Improved performance • Partition elimination speeds table scans • Reduced costs • Automatically place less used data on lower cost storage

  37. Oracle Database 11g Partitioning • Major New Partitioning Enhancements • Partition by parent / child reference • e.g., partition orders and order_lines together • Virtual column partitioning • e.g., partition on “virtual” order status “active”, “less active”, etc. derived from multiple status fields in order record • More composite partitioning options • List/Range, Range/Range, List/Hash, List/List • e.g., Order Status/Month, Month/Day • Automatic interval partitioning • e.g., create new partition every month • Single partition transportable tablespace

  38. Select * from orders AS OF ‘Midnight 31-Dec-2003’ ORDERS Archive Tables Changes User Tablespaces Flashback Data Archive Oracle Database 11g Flashback Data Archive • Flashback Data Archive • Easy, practical way to add “time dimension” to your data • For change tracking, ILM, auditing, compliance, … • Query data “AS OF” any time in the past • Efficient storage / retrieval of undo data • Fast query access to very old data • Can specified retention policy to automatically purge old data Total Recall

  39. FlashbackQuery FlashbackTables FlashbackDatabase Flashback for Rapid Recovery from Human Error FlashbackData Archiveand Transaction

  40. Enhance Performance Major New Performance Innovations

  41. Advanced Compression in Oracle Database 11g

  42. Storage Challenges • Volume of managed data has exploded recently • Government regulations (Sarbanes-Oxley, HIPPA, etc) • User generated content (Web 2.0) • Mass adoption of rich multimedia content (audio, video, etc) • IT managers expected to reduce technology budgets • Need to optimize storage consumption • Also maintain acceptable application performance

  43. Standby Redo Logs Backups Introducing Advanced Compression • Advanced compression in Oracle Database 11g • Structured data compression • Unstructured data compression • Compression for backup data • Network transport compression • Reduces resource requirements and costs • Storage System • Network Bandwidth • Memory Usage

  44. Structured Data CompressionFor OLTP and Data Warehousing Applications • Oracle introduced table compression in Oracle9i Database • Support for bulk load operations • Oracle Database 11g extends compression for OLTP data • Support for conventional DML Operations • Support for add/drop columns on compressed tables • Significantly reduces disk space consumption • Typically 2 to 3x • Improves the performance of queries • Up to 2x performance improvements for long running queries • No uncompression required while reading compressed data • Completely transparent to applications

  45. Unstructured Data CompressionOracle SecureFiles • New feature in Oracle Database 11g • Secure, high performance, storage optimized solution • Documents, spreadsheets, images, multimedia, etc. • SecureFile Compression • Automatically determines if SecureFile data is compressible • 2 to 3x compression for typical files • Industry standard compression algorithms • Multiple compression levels optimize performance & space

  46. Secure hash SecureFile De-duplication • Multiple copies of identical SecureFiles are stored once • Faster performance for writes and copy operations • May improve read performance • Huge reduction in disk space usage • Great for document management, email archiving etc.

  47. Backup & Network Data Compression • Data Pump compression • Compresses data unloaded from the database • Single step compression of both data and metadata • Fast Recovery Manager (RMAN) compression • 40% faster backup compression • Data Guard network compression • Compression of redo traffic over the network during redo gap resolution • Improves redo transport performance • Gap resolution is up to 2x faster

  48. Advanced Compressionin Oracle Database 11g • Comprehensive set of data compression capabilities • Structured, unstructured, backup, network transport • Reduces storage consumption by 2 – 3 times • Savings cascades into test, dev, QA, backup, DR environments • Improves application performance • Enhances memory and network efficiency • Complete application transparency • Benefits diverse application workloads • Transaction Processing • Data Warehousing • Content Management

  49. Major New Performance Innovations • SecureFiles • New generation LOBs just as fast as files • Table Compression • Now for OLTP as well as DW applications • Next Generation RAC Cache Fusion • Even more scalable • Query Results caches • Fast caching of query/function results for read-mostly data

More Related