
041e8aeea4a4c0cec0f2d4f067268109.ppt
- Количество слайдов: 33
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
Growing Data Volumes 100 80 Database Size 60 (TB) 40 Size of the largest data warehouse in Winter Corp Survey 245% increase from 2003 to 2005! 20 0 1998 1999 2000 2001 2002 2003 2004 2005 Source: 2005 Top. Ten Program, November 2005 © Winter Corporation, Waltham, MA, USA
Uptake (TAR Analysis) 5% 36% 59% Source: TAR Analysis (April 2007)
Infrastructure Complexity • Understanding the Costs • Number of things costs = N • Number of connected things = (2 N) • Number of KINDS of things = N^N Complexity Cost Curve • Complexity Slows Change • More failure points • Uneven levels of process Maturity • Functionality+Virtualization=Agility • Functionality enables agility • Virtualization masks functional complexity Oracle Grid is Enabling Enterprise Agility by Attacking Complexity
The 11 g Big Message • 11 g Lowers overall costs while increasing business and IT agility! • Simplifies your information infrastructure! • Enables change to happen while maintaining stability! • Takes management and diagnostic automation to the next level! • Freeing key personal for higher value tasks! • Provides the least expensive, most scalable, secure and highly available rapid application development environment! Traditional Performance Dimensions of Scalability and Availability Are Now Table Stakes. Agility is the X-Factor
Defining Value Innovation • Lowers the cost while increasing Agility • Simpler (automates/obfuscates complex tasks) • Cheaper (lower TCO via improved sustainability) • More Convenient to Use • Most likely already own it • Solid skills base foundation • Single vendor to manage • Simplifies infrastructure landscape • Fundamentally changes how a task or process has been done in the past Value innovation fundamentally changes how one evaluates a product category
Oracle Database Innovation 30 years of sustained innovation … Audit Vault Database Vault Grid Computing Self Managing Database XML Database Oracle Data Guard Real Application Clusters Flashback Query Virtual Private Database Built in Java VM Partitioning Support Built in Messaging Object Relational Support Multimedia Support Data Warehousing Optimizations Parallel Operations Distributed SQL & Transaction Support Cluster and MPP Support Multi-version Read Consistency Client/Server Support Platform Portability Commercial SQL Implementation 1977 … continuing with Oracle Database 11 g 2007
Bucking Conventional Wisdom By The Book Oracle Platform dependent Portable C code base Read & write locks Multi-version concurrency Combined undo/redo log Undo stored in the database Static SQL compilation Just-in-time SQL compilation Shared nothing clusters Parallelism tied to partitions Store some of your data Shared disk/shared cache clusters Parallelism orthogonal to partitions Store all your data
Where We’ve Been, Where We’re Going Database 1. 0 Users Applications Data Hardware Storage Scalability Workload Consolidation HA Management Pricing Database 2. 0 In-house Everyone Vertical Silos Horizontal Services Chars, Numbers, Dates All Your Data SMP/Mainframe Network/Virtualized Expensive, Siloed Inexpensive, Shared High Cost Scale Up Low Cost Scale Out Specialized-Separate DW-OLTP Slow TTV Converging Workloads, Fast TTV Difficult, Expensive Easy, Low Cost Monitor and Manage Alert and Automate CPU or User Socket or Site
Top 11 g new features
Physical Standby with Real-Time Query Real-time Queries Concurrent Continuous Redo Shipment and Apply Primary Database Real-Time Query Physical Standby Database • 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 • •
Set up Test Environments using Snapshot Standbys • Physical Standby Apply Logs Open Database Back out Changes 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 Snapshot Standby Perform Testing Continuous Redo Shipping
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
Pre-Change Production System Client … Changes Unsupported App Server Changes Supported • Database Upgrades, Patches • Schema, Parameters • RAC nodes, Interconnect • OS Platforms, OS Upgrades Process … Process Captured Workload Capture Workload … • CPU, Memory • Storage • Etc. Backup
Pre-Change Production System Client Post-Change Test System Client … Replay Driver App Server Process … Processed Captured Workload … Process Capture Workload … Backup Can use Snapshot Standby as test system … Replay Driver … Process … … Process
SQL Performance Analyzer • 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 (10 g) to improve performance with SQL Profiles • Changes supported • Major & minor database releases, patches, parameters, schema, optimizer statistics, tuning recommendations
SQL Performance Analyzer
SQL Plan Management controlled 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
Flashback Data Archive Select * from orders AS OF ‘Midnight 31 -Dec-2004’ • Automatically stores all changes to selected tables • Archive cannot be modified ORDERS Changes User Tablespaces Archive Tables Flashback Data Archive Oracle Database • View table as of any time • Uses: • Change Tracking • ILM • Long term history - years • Auditing • Compliance
EM Support Workbench Overview • Wizard that guides you through the process of handling problems • You can perform the following tasks with the Support Workbench: • View details on problems and incidents • Run health checks • Generate additional diagnostic data • Run advisors to help resolve problems • Create and track service requests through Meta. Link • Generate incident packages • Close problems once resolved
Support Workbench
Incident Packaging Service
Manageability Evolution Adaptive Auto-Tuning ed Integrat Advisory ct Low Impa Replication Recovery RAC Schema Apps/SQL Memory Backup Storage Instrumentation
Manageability in 11 g? • More database administration automation • More intelligent advisors to simplify administration • Fault diagnostic automation • Enhancements to existing features
Manageability Comparison of Oracle Database 9 i, 10 g, and 11 g Summary Oracle 9 i vs. 10 g § 44% less time Oracle 10 g vs. 11 g § 26% less time § 47% fewer steps § 31% fewer steps
DB Management Pack Enhancements • Diagnostic Pack • ADDM for RAC • AWR Baselines • Transportable AWR • Tuning Pack • Automatic SQL Tuning Advisor • Partition Advisor • SQL Monitoring • SPM Automatic Plan Evolution
Data Compression for All Applications • Oracle 9 i compresses data only during bulk • • load; useful for DW and ILM Oracle 11 g compresses w/ inserts, updates Typical compression ratio of 2 x to 3 x Database directly reads compressed data eliminating decompression overhead Strategy: compress db’s 10 largest tables • Shrink table data by 50%, increase CPU by 5% • Savings cascade to all db copies: test, dev, standby, mirrors, archiving, backup, etc.
Oracle Secure. Files High-Performance Large Objects • High-performance transactional access to large object data • documents, medical, CAD, imaging … • low-latency, high throughput, concurrent access • space-optimized storage • Protect your valuable data. . in the db! • • transactions transparent encryption compression and de-duplication database-quality security, reliability, and scalability • Better security, single view and management of data • Superset of LOB interfaces – easy migration
Secure. Files Breaks the Performance Barrier! File Read Performance (MB/second) Secure. Files Linux Files LOBs File Size (MB) • Innovative technology for high performance large object data • Smart buffering, write gathering, intelligent locking • Fast bulk data transfers, LOB prefetch • Much faster than LOBs with more capabilities • File system-like performance with database functionality!
Oracle Partitioning 10 years of innovation Core functionality Oracle 8 Range partitions, global range index Oracle 8 i Hash and composite range-hash partitioning Oracle 9 i List partitioning Oracle 9 i R 2 Composite range-list partitioning Oracle 10 g Global hash indexes Oracle 10 g R 2 1 M partitions per table
Oracle Partitioning 10 years of innovation Core functionality Oracle 8 Range partitions, global range index Oracle 8 i Hash and composite range-hash partitioning Oracle 9 i List partitioning Oracle 9 i R 2 Composite range-list partitioning Oracle 10 g Global hash indexes Oracle 10 g R 2 1 M partitions per table Partitioning by reference Virtual column partitioning New composite partitioning: range-range, list-list, list-hash
New Partitioning Features • New composite partitioning schemes Range List Hash 11 g 9 i 8 i 11 g 11 g Range List • Partition (or index) on virtual (computed) columns • Partition advisor • Automatic range partition creation • Partition by REFERENCE (primary key of parent)
041e8aeea4a4c0cec0f2d4f067268109.ppt