oracle database 11g overview
DESCRIPTION
Oracle Database 11g OverviewTRANSCRIPT
<Insert Picture Here>
The Future of Database TechnologyMark TownsendVice President, Database Product Management
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.
Agenda
• Database Update• Information Appliance Initiative• Information Lifecycle Management• Security and Compliance• What’s Next – Change Assurance
Uptake (TAR Analysis)
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Mar-01
Jun-01
Sep-01
Dec-01
Mar-02
Jun-02
Sep-02
Dec-02
Mar-03
Jun-03
Sep-03
Dec-03
Mar-04
Jun-04
Sep-04
Dec-04
Mar-05
Jun-05
Sep-05
Dec-05
Mar-06
Jun-06
Sep-06
Oracle Database 10g Oracle9i Oracle8i Oracle8 and Earlier
Source: TAR Analysis (October 2006)
48%
44%
7%
Oracle’s 10g Grid Strategy
• Enable Grid Computing• Using Low Cost Servers and Storage
• With Intelligent Software• Database Servers and Fusion Middleware
• And Automated Management Tools• Reducing Errors and Lowering Costs
• To Modernize I/T Infrastructure • Highest QoS and Flexibility, Lower Cost
Oracle 10g Grid
Real Application
Clusters
Automatic Storage
Management
Application Server
Clusters
Grid Control
ExtractServers
1. Extract from source systems
2. Integrate, transform, and denormalize
3. Query and analyze
4. Data access and publishing
ETLManager
Amazon’s RAC is so cost-effective they run 2 concurrently and still save money.
2nd pair of identical RAC clusters means ‘no need for backup’ for active online data
8 nodes x 4CPUs12 TB+ STAGE
Amazon Data Warehouse Modular Architecture using Oracle Database 10g RAC and ASM on Linux
16nodes x 4CPUs65 TB QUERY
Emerging Trends for DW
• Data warehouses have become ubiquitous parts of the IT infrastructure
• Problem: Data warehouse system configurations are easy to get wrong
• Goal: Make it easy to deliver• A scalable system• With reduced implementation times• Eliminated deployment risks• Lower cost
DW Configuration Problem: I/O
Database CPUs Memory Actuators LUNs Disks Raid
Database CPUs Memory Actuators LUNs Disks Raid
An unbalanced configuration
A balanced configuration
100%Possible
Efficiency
100%Possible
Efficiency
100%AchievedEfficiency
< 50%AchievedEfficiency
Oracle Information Appliance Initiative
• 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
Information Appliance – An ExamplePanta 2700 Data Warehouse Appliance
• 8 Blade RAC cluster• 4 AMD 2.2Ghz dual core
processors per blade• 8 GB memory per processor• Total of 64 cores and 256 GB
memory• 96 TB database storage
• 532 disk drives• 250GB SATA 7200 RPM / drive
• 2 Silverstorm 9024 InfinibandSwitches
• Up to 12 GB / sec I/O throughput observed in database processing
• Oracle Database 10g with RAC and Partitioning
• Red Hat Enterprise Linux Advanced Server 4 Update 3
Information Appliance:New 1TB TPC-H Announced
• The system: • Oracle Database 10g Release 2 with Real Application Clusters
and Partitioning• 8-node PANTAmatrix (aka Panta 2700 Data Warehouse
Appliance)• Red Hat Enterprise Linux Advanced Server 4 Update 3
• The results: • Performance: 59,353.9 QphH@1000GB • Price-performance: $24.94 $/QphH@1000GB
• Compelling combination of performance and price-performance: • #2 in absolute performance• #2 in price-performance
As of October 23, 2006: PANTA Systems PANTAmatrix, 59,353.9QphH@1000GB, $24.94/QphH@1000GB, available 4/15/07.
Source: Transaction Processing Performance Council (TPC), www.tpc.org
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
$2,402,000
$842,000
$1,560,000
224 spindles (150GB each)
2
8250z 1)
532 spindles (250GB each)Disks
$2,171,569
$1,019,140
$1,152,429
3
PANTA 2700
# Racks
Total 3YR Cost of Ownership
HW/SW Costs
3 Yr Maintenance
1) Netezza, 2006 Whitepaper “How the Simplicity of the NPS Data Warehouse Appliance Lowers TCO”
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
Active Data Less Active Data Historical Data
Typical Database Implementation without ILM
DIGITAL DATA STORAGE
High PerformanceStorage Tier
Active Less Active Historical Archive
Data Lifecycle
TapeArchive
Storage Sample Device Costs
Low End
High End
max$/GBmin $/GBStorage Tier Vendor
$28.80$22.80IBM DS8300 73GB, <6TB
$23.90$18.90HP XP128 73GB, < 6TB
$7.50
$8.90
$10.40
$34.10
$5.90IBM DS4300 146GB, <4TB
$7.00HP EVA 3000 146GB, <4TB
$8.20EMC CX500 146GB, <4TB
$26.90EMC DMX 1000 73GB, <6TB
• Prices in high end range typically represent a system configured for performance• Prices in the low end range typically represent a system configured for capacity
$29.00
$7.00
Solution: Match Storage to Lifecycle Optimize Cost
High PerformanceStorage Tier
Low CostStorage Tier
Online ArchiveStorage Tier
Active Less Active Historical Offline
Archive
Data Lifecycle
DIGITAL DATA STORAGE
Offline Archive
Storage
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 tiersActive
LessActive
Historical
Database+ Partitioning
ILM Assistant
Database Features for ILM
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 • New Interval, Ref and Virtual
Column Partitioning• New Composite Partitioning
• Range Range, List Range, List List, List Hash
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 DatabaseOracle Database Vault
Regulatory Compliance• SOX, Basel II, HIPAA, J-SOX, GLB, Privacy laws• Adequate IT controls• Separation of Duty• Proof of compliance• Risk assessment and monitoring
• 80% of threats come from insiders• 65% of internal threats are undetected• 50% customers looking at monitoring insider/DBA threats
Insider Threats and Theft
Drivers for Compliance & Security
Database Security and Compliance Products
AdvancedAdvancedSecuritySecurity
LabelLabelSecuritySecurity
EncryptedEncryptedDataData
DataDataClassificationClassification
Database Security and Compliance Products
AdvancedAdvancedSecuritySecurity
LabelLabelSecuritySecurity
DatabaseDatabaseVaultVault
MultiMulti--factorfactorDBA ControlsDBA Controls
EncryptedEncryptedDataData
DataDataClassificationClassification
SecureSecureBackupBackup
EncryptedEncryptedData on TapeData on Tape
SecureSecureSearchSearch
AuthorizedAuthorizedSearchSearch
AuditAuditVaultVault
Monitor, Alert,Monitor, Alert,ConsolidateConsolidate
Beta
Database Vault and Audit Vault Demonstration
What is the next big challenge ?
<Insert Picture Here>
“The art of progress is to preserve order amid change and to preserve
change amid order.”
Alfred North Whitehead:Principia Mathematica
Oracle Database 11g will focus on helping you preserve order amid change
New Change Assurance Capabilities in Oracle Database 11g
Capture &Replay
Workload
Set Up TestEnvironments
Detect &Tune
PerformanceChanges
PackageIncidents
forSupport
OnlineHot
Patching
Workload Capture and Replay -Database Replay
• Database Capture• Records DB production
workload including critical concurrency characteristics
• Database Replay• Replays workload with
actual timing• Analysis & Reporting
• Error reporting• Data divergence • Performance divergence• ADDM for further
performance analysis
Rec
Analysis & Reporting
Record & Replay
Beta
Workload Capture and Replay –SQL Replay
• Focus on impacts on SQL query workload• Fine-grain performance analysis on individual SQL
• Captures SQL Workload in Production• Captures SQL text, plans, bind variables, execution statistics• Over specified period• Can capture Oracle Database 10g Release 2 SQL workload
• Replays SQL Workload in Test• Test executes SQL on test system• Identifies SQL with different plans and SQL with slower
performance• For regressed SQL, use SQL Tuning Advisor (10g) to tune• Produces analysis & reports
Beta
Test Database
Production Database Redo
Shipment and Apply
Oracle Confidential
Works with Standby Databases
CAPTURERec REPLAY
Beta
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 • Can Replay Workload against
Physical Standby Apply Logs
Snapshot Standby Perform Testing
Open Database
Back out Changes
Beta
Rolling Database Upgrades Using Transient Logical Standby
• Logical standby allows rolling upgrades but has data type restrictions
• Temporarily convert physical standby to logical to perform a rolling upgrade• Data type restrictions are limited to short
upgrade window
• No need for separate logical standby for upgrade
Physical
Logical
Upgrade
PhysicalAlso possible in 10.2 with more manual steps
SQL ReplayEvaluate Impact of Database Change on SQL Performance
Compare Performance
Pre-Change Environment
Replay Production SQL and Gather Stats
Make Change
Post-Change Environment
Replay SQL
Tune SQL
Tuned Environment
SQL Tuning AdvisorReplay SQL
SQL Replay Demonstration Beta
Online Table & Index Redefinition• All index changes can be done online
• Create new index, move index, defragment index• Tables can be Reorganized & Redefined online
• Table contents are copied to a new table• Defragments and allows changing location, table type, partitioning
• Contents can be transformed as they are copied• Can change columns, types, sizes - specified using SQL “Select”
Source Table
Update Tracking
Transform CopyTable
TransformUpdates
GUI interface to make it
Simple
Result Table
Continuous Queries & Updates
Store Updates
Online Application Upgrade
• Large, mission critical applications are often unavailable for tens of hours while an upgrade is installed
• Oracle Database 11g introduces revolutionary new capabilities that allow online application upgrade with continuous availability of the application
• The pre-upgrade application and the post-upgrade application can be used at the same time
• Each end-user session is rolled over on its own schedule
Beta
Online Application Upgrade Demo
How do we do it?
• Oracle Database 11g 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
Sometimes you still need to log a TAR
### This is a critical production system ### = YES
ACTION PLAN============1. Upload trace files from both nodes.2. Any trace file created on the background_dump_dest
since the time of the problem.3. Hanganalyze trace and system state dump from
the instance that is running….
The customer :XYZ : has uploaded the following file via MetaLink: ….
The customer : XYZ : has uploaded the following file via MetaLink: ….
….
ACTION PLAN============1. I could not find between the trace files lmon trace,
smon, pmon etc. Please upoload any trace file created on the background directory from any of the nodes today.
….
The customer :XYZ : has uploaded the following file viaMetaLink: ….
The customer : XYZ : has uploaded the following file viaMetaLink: ….
….ACTION PLAN============1. Please upload the lmon,lms,lck,lmd traces for RAC
and all trace files for all bg process2. Please upload OS logs and sun Cluster dlm logsThe customer :XYZ : has uploaded the following file via
MetaLink: ….The customer : XYZ : has uploaded the following file via
MetaLink: ….
….
CCR Collector
Automatic Diagnostic Repository
Automatic Diagnostic Workflow -Reduce Time to Problem Resolution
Duplicate Bug?
Yes
EM Support Workbench:Apply Patch or WorkaroundGuided Repair
No
EM Support Workbench:Package Incident information
including CCR infoGuided Repair
Incident Packaging ServiceFirst-failure Capture
Critical
Error
Alert DBATargeted assessmentsAssisted SR Filing
Auto Bug Matching (post 11gR1)
1 2 3
45
Oracle Confidential
Beta
Support for Online Hot Patching
• 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
Beta
Other Oracle Database 11g Highlights
• High Availability• Flashback Archive• Flashback Transaction
• Performance and Scalability• RAC Scalability Enhancements• Query Result Cache• Partition Advisor• I/O Resource Management
• Security• Tablespace and LOB
Encryption• Business Intelligence
• Next generation OLAP• Supermodels for Data Mining
• Manageability andDiagnosability
• Support Workbench• SQL Test Case Builder• ADDM for RAC• Automatic Health Monitoring
• Content Management Infrastructure
• Binary XML storage• Enhanced XML indexing• LOB’s as fast as filesystems• DICOM Medical Imaging
Support• Storage & Query of Semantic
Content
Discussion Points
• XML Publisher• Fusion Security• R2 focus – Plug and Play Clustering
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.