Transcript 11g General New Features

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 TopTen Program, November 2005 © Winter Corporation, Waltham, MA, USA
Uptake (TAR Analysis)
5%
90%
36%
60%
59%
20%
10%
Mar.07
Ara.06
Eyl.06
Haz.06
Mar.06
Ara.05
Eyl.05
Haz.05
Mar.05
Ara.04
Eyl.04
Haz.04
Mar.04
Ara.03
Eyl.03
Haz.03
Mar.03
Ara.02
Eyl.02
Haz.02
Mar.02
Ara.01
Eyl.01
Haz.01
Mar.01
Source: TAR Analysis (April 2007)
Oracle8 and Earlier
Oracle8i
Oracle9i
Oracle Database 10g
100%
80%
70%
50%
40%
30%
0%
Infrastructure Complexity
Complexity Cost Curve
• Understanding the Costs
• Number of things costs = N
• Number of connected things = (2N)
• Number of KINDS of things = N^N
• Complexity Slows Change
• More failure points
• Uneven levels of process Maturity
• Functionality+Virtualization=Agility
• Functionality enables agility
• Virtualization masks functional complexity
90
80
70
60
50
40
30
20
10
0
1
2
3
# of Things
4
5
6
7
8
# of Kinds
# of Connections
Oracle Grid is Enabling Enterprise Agility by Attacking
Complexity
The 11g Big Message
• 11g 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 11g
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
Users
Applications
Data
Hardware
Storage
Scalability
Workload
Consolidation
HA
Management
Pricing
Database 1.0
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 11g 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
Snapshot Standby
Perform Testing
• 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
Continuous Redo Shipping
• Single copy of storage
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
Client
Client
…
Changes
Unsupported
App
Server
App
Server
App
Server
Changes
Supported
•Database Upgrades, Patches
•Schema, Parameters
•RAC nodes, Interconnect
•OS Platforms, OS Upgrades
Process
Process
…
Process
Captured
Workload
Capture Workload
…
•CPU, Memory
•Storage
•Etc.
Backup
Pre-Change Production System
Client
Client
Post-Change Test System
Client
…
Replay
Driver
App
Server
App
Server
App
Server
Process
Process
…
Processed
Captured
Workload
Process
…
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 (10g) 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
Archive
Tables
User
Tablespaces
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 MetaLink
• Generate incident packages
• Close problems once resolved
Support Workbench
Incident Packaging Service
Manageability Evolution
Auto-Tuning
Advisory
Instrumentation
Manageability in 11g?
• More database administration automation
• More intelligent advisors to simplify administration
• Fault diagnostic automation
• Enhancements to existing features
Manageability Comparison of Oracle
Database 9i, 10g, and 11g
100%
75%
9i
10g
11g
50%
25%
0%
Time
Steps
Summary
Oracle 9i vs. 10g
 44% less time
Oracle 10g vs. 11g
 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 9i compresses data only during bulk
load; useful for DW and ILM
• Oracle 11g compresses w/ inserts, updates
• Typical compression ratio of 2x to 3x
• 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 SecureFiles
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
SecureFiles Breaks the
Performance Barrier!
File Read Performance
(MB/second)
120
100
80
60
40
20
0
SecureFiles
Linux Files
LOBs
0,1
1
10
File Size (MB)
100
• 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
Oracle8
Range partitions, global range index
Oracle8i
Hash and composite range-hash partitioning
Oracle9i
List partitioning
Oracle9i R2
Composite range-list partitioning
Oracle 10g
Global hash indexes
Oracle 10g R2 1M partitions per table
Oracle Partitioning
10 years of innovation
Core functionality
Oracle8
Range partitions, global range index
Oracle8i
Hash and composite range-hash partitioning
Oracle9i
List partitioning
Oracle9i R2
Composite range-list partitioning
Oracle 10g
Global hash indexes
Oracle 10g R2 1M partitions per table
Partitioning by reference
Virtual column partitioning
New composite partitioning:
range-range, list-range,
list-list, list-hash
New Partitioning
Features
• New composite partitioning schemes
Range
List
•
•
•
•
Range
List
Hash
11g
9i
8i
11g
11g
11g
Partition (or index) on virtual (computed) columns
Partition advisor
Automatic range partition creation
Partition by REFERENCE (primary key of parent)