1
<Insert Picture Here> Oracle Database 11 g Overview Gary Quarles Sales Consultant
Oracle Database 11 g • 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
Sustained Innovation – Grid Computing SMP Dominance RAC Clusters for Availability Grids of low cost hardware and storage 4
Well Proven Scalability • RAC 8+ node customers • • • Citigroup Burlington Coat Factory J 2 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 My. Travel Thompson AOL Vivo Sagawa Kyubin 5
Example: Amazon Data Warehouse • 51 TB row data 16 Node RAC Linux Cluster 4 CPUs per Node • 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 • 50 x growth in data in 6 years • More than doubled in last year 8 SAN switches, 32 port each Switch 84 HP MSA-1000 Arrays 6
Benefits Achieved • Scalability - Easily Expanded Original 10 Node Cluster to 18 Nodes • Easier, Less Disruptive Storage Changes with ASM • Improved Availability • Significant Cost Savings, Better IT Productivity • Disaster Tolerance with Dataguard 18 -node cluster IBM x-Series Data Center 1 Oracle RAC 10 g. R 2 IBM x. Series – SUSE Linux SKU 1 DB SK DB U 3 SKU • Better Performance - Large Queries – 50% Faster Data Center 2 d Stanor f by 5 SKU -8 DBs 4 DB 2 DB SKU 5 DB 6 DB SKU 7 SKU Dataguar d SKU d Stanor by f 1 SKU -4 DBs 8 DB DB Oracle ASM – Two diskgroups, one SAN, one SATA 7
Mark Beyer, Gartner December 2006 “Oracle customers are highly satisfied with its Real Application Clusters and Automatic Storage Management when pursuing scaleout 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 Database 11 g 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
<Insert Picture Here> Make Change Safe Enabling Change While Maintaining Stability
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
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 Analysis & Reporting 15
Database Replay: Supported Changes Client … Client Changes Unsupported Middle Tier Changes Supported • Database Upgrades, Patches Recording of External Client Requests • Schema, Parameters • RAC nodes, Interconnect • OS Platforms, OS Upgrades Storage • CPU, Memory • Storage • Etc. 16
Comparison of Load. Runner & DB Replay Testing e-Business Suite 80 24 4 20 20 5 0 0 2 5 Total Testing Time DB Replay: 2 weeks Load. Runner: 30 weeks 17
Why DB Replay? From: Artificial workloads Production workloads Partial workflows Complete workflows Months of development Days of development Manual intensive 150 Days To: Automated High risk Low risk 10 Days 18
Database Replay Workflow Production (10. 2. 0. 4) Clients Test (11. 1) … Replay Driver Mid-Tier … Storage Capture Process Replay Analysis & Reporting 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
<Insert Picture Here> Automate Still More Administrative Functions Freeing key personal for higher value tasks!
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 Oracle 9 i • Major focus in Oracle Database 10 g • Continued major focus in Oracle Database 11 g • Three step process • Instrumentation – lays measurement infrastructure • Advisory – monitors the administrative function, identifies suboptimal 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 Replication Recovery RAC Schema Apps/SQL Memory Backup Storage Instrumentation 24
Self Managing Database Auto-Tuning Advisory Replication Recovery RAC Schema Apps/SQL Memory Backup Storage Instrumentation 25
ADDM for RAC Database-Level ADDM 11 g • Self-Diagnostic Engine • • Instance-Level ADDM Inst 1 AWR 1 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: • Inst 2 AWR 2 Inst 3 AWR 3 • • Global cache interconnect issues Global resource contention, e. g. IO bandwidth, hot blocks Globally high-load SQL Skew in instance response times 26
Automatic SQL Tuning Packaged Apps Custom Apps Auto Capture High -Load SQL Nightly Automatic SQL Tuning SQL Profiles Automatic implement SQL Analysis • Automatically captures highload SQL • Automatically tunes SQL by creating SQL Profiles • Automatically implements (optional) greatly improved SQL plans • Automatically reports analysis • Automatically runs during maintenance window Report Manually implement Well-tuned SQL 27
Partitioning Advisor Packaged Apps Custom Apps SQL Workload SQL Advisor SQL Plan Access Structure Tuning Analysis SQL Profile SQL Advice Indexes & MVs Well-tuned SQL & Schema New! Partition Analysis Partition Advice • 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 28
Automatic Memory Tuning OS Memory DB Shared Memory • Automatically adapts to workload changes • Maximize memory utilization • Single dynamic memory parameter • Helps eliminate out-of-memory errors DB Process Memory 29
<Insert Picture Here> Simplify Systems Simplify Your Information Infrastructure For Maximum Agility and Lowest Cost!
Old Pre-Grid Infrastructure DSS HR DSS Standby HR Standby Finance Standby 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
Oracle Database 10 g Database Grid HR Financials DSS Consolidate Workloads to a Single… 33
Oracle Database 10 g Storage Grid HR Financials DSS Automatic Storage Management Low Cost Module Storage Monolithic Storage 34
Oracle Database 11 g 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 11 g Secure. Files • 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 11 g 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 11 g 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 transportablespace 38
Oracle Database 11 g 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 Select * from orders AS OF ‘Midnight 31 -Dec 2003’ ORDERS Changes User Tablespaces Archive Tables Flashback Data Archive Total Recall 39
Flashback for Rapid Recovery from Human Error Flashback Query Flashback Tables Flashback Database Flashback Data Archive and Transaction 40
<Insert Picture Here> Enhance Performance Major New Performance Innovations
Advanced Compression in Oracle Database 11 g
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
Introducing Advanced Compression • Advanced compression in Oracle Database 11 g • • Structured data compression Unstructured data compression Compression for backup data Network transport compression • Reduces resource requirements and costs • Storage System • Network Bandwidth • Memory Usage Redo Logs Standby Backups 44
Structured Data Compression For OLTP and Data Warehousing Applications • Oracle introduced table compression in Oracle 9 i Database • Support for bulk load operations • Oracle Database 11 g 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 3 x • Improves the performance of queries • Up to 2 x performance improvements for long running queries • No uncompression required while reading compressed data • Completely transparent to applications 45
Unstructured Data Compression Oracle Secure. Files • • New feature in Oracle Database 11 g Secure, high performance, storage optimized solution Documents, spreadsheets, images, multimedia, etc. Secure. File Compression • • Automatically determines if Secure. File data is compressible 2 to 3 x compression for typical files Industry standard compression algorithms Multiple compression levels optimize performance & space 46
Secure. File De-duplication • • Multiple copies of identical Secure. Files 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. Secure hash 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 2 x faster 48
Advanced Compression in Oracle Database 11 g • 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 • Secure. Files • 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 50
Major New Performance Innovations • Times. Ten • Application tier in-memory database gets even more compatible with Oracle, more functional, and faster • And much more … • • Faster Data Guard and Streams replication Faster PL/SQL and Java (automatic native compilation) Faster triggers Faster simple SQL operations Faster NFS storage access (Auto. NFS) Faster upgrades Faster backup/restore for large files Faster backup compression 51
<Insert Picture Here> Enrich Information Management and Application Development Across the board improvements in information management and application development tools
Information Management Highlights • Security • Transparent tablespace and LOB Encryption • Business Intelligence • OLAP integration with materialized views • Simplified Data Mining • Integration • Faster Gateways • New mainframe Gateways • Distributed Scheduler • XML DB • Binary XML storage • Enhanced XML indexing • Schema evolution • inter. Media • Comprehensive DICOM medical imagery support • 3 X faster image processing • Spatial • 3 D support • Improved maps 53
Application Development Highlights • PL/SQL • Automatic compilation • Java and JDBC • Automatic JIT compilation • “Like JDK” ease of use • Windows and. NET • Vista support • Windows backup (VSS) • PHP • Database Resident Connection Pool • Application Express • Microsoft Access application migration • Reporting – BI Publisher • Flash charting • Declarative “Ajax” support • WYSIWYG editing • SQL Developer • Version Control • Visual Query Builder • Migration Workbench integration 54
Other Oracle Database 11 g Highlights • High Availability • Automatic Storage Management • Snapshot Standby • Rolling upgrades • Logminer, Physical Standby, Streams • Automatic bad block repair support for XMLType, TDE • Fast disk array resync • Fast Start Failover with Async • Preferred read for geo clusters Propagation • Manageability and Diagnosability • Flashback Transaction • Automatic Health Monitoring • One step duplicate DB or create • PL/SQL standby over the network • Fine-grained dependency tracking • Security • Dynamic SQL enhancements • Secure By Default • Performance analysis aids • Comprehensive Enterprise Manager support • Content Management • Business Intelligence • Storage & Query of Semantic Content (RDF, OWL) • Comprehensive Enterprise Manager • Secure Enterprise Search connectors support • Text improvements • PIVOT/UNPIVOT operators 55
Q & A QUESTIONS ANSWERS 56
Скачать презентацию 1 Insert Picture Here Oracle Database 11
3a183315866976d9b53fe5973e2576cb.ppt