1

<Insert Picture Here>

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
• 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 RAC Grids of

Dominance Clusters low cost
for hardware and
Availability storage

4
 Well Proven Scalability

• RAC 8+ node customers

• Citigroup • SAIC
• Burlington Coat Factory • Fairmont Hotels
• J2 Global Communications • ADESLAS
• Genworth Financial • Evite.com
• Amazon.com • Quelle AG
• MSDS • Telstra
• Mercado Libre • Gas Natural
• Yahoo! Overture • MyTravel
• Babcock Engineering • Thompson
• Ordnance Survey • AOL
• Dell • Vivo
• Yahoo! • Sagawa Kyubin

5
 Example: Amazon Data Warehouse

16 Node RAC Linux Cluster

• 51 TB row data 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 8 SAN switches, 32 port each
Switch Switch Switch
Warehouses in Winter Survey
• 50x growth in data in 6 years
• More than doubled in last 84 HP MSA-1000 Arrays
year

6
 Benefits Achieved
•Scalability - Easily Expanded Original 10 Node •Better Performance - Large Queries – 50% Faster
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 Data Center 2

d
Oracle RAC 10gR2 Stanor d
f Stanor
by
IBM xSeries – SUSE Linux
SKU by f U
5-8 SK
DB 6 DB 1-4
SKU
3 DBs SKU DBs
1 DB 5 DB
SKU SKU
4 DB DB
SKU SKU
8

2 DB
SKU 7 DB
SKU
Oracle ASM – Two
Dataguar diskgroups, one SAN,
d one SATA

7
 Mark Beyer, Gartner
December 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
 <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 Analysis & Reporting
• Performance divergence

15
 Database Replay: Supported Changes

Client Client Client

…
Changes
Unsupported
Middle Tier

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

16
 Comparison of LoadRunner & DB Replay
Testing e-Business Suite

80
80
Time Taken (Days)

60

40
24
20 20
20 5 LoadRunner
4 0 0 2 5 DB Replay
0
Install & Setup Understand Identify Key Generate Run Test
Application Transactions Workload
Usage

Total Testing Time

DB Replay: 2 weeks
LoadRunner: 30 weeks

17
Why DB Replay?

From: To:
Artificial workloads Production workloads

Partial workflows Complete workflows

Months of development Days of development

Manual intensive Automated

150 High risk Low risk 10

Days Days

18
 Database Replay Workflow
Production (10.2.0.4) Test (11.1)
Clients
… Replay Driver

Mid-Tier

Storage
Storage

Analysis &
Capture Process Replay
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 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

Instrumentation

Replication
Recovery
RAC
Apps/SQL
Memory
Backup
Storage

Schema

24
 Self Managing Database

Auto-Tuning

Advisory

Instrumentation

Replication
Recovery
RAC
Apps/SQL
Memory
Backup
Storage

Schema

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

26
 Automatic SQL Tuning

• Automatically captures high-

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

27
 Partitioning Advisor
Packaged Custom
Apps Apps

SQL Workload New! • Considers entire query

workload to improve query
SQL Advisor
SQL
performance
SQL Plan Access Partition
Tuning
Structure
Analysis Analysis • Advises on partitioning
Analysis
methods
• Range (equal-interval), range
SQL SQL Indexes Partition key and interval
Profile Advice & MVs Advice
• Hash, hash key
• Integrated, non-conflicting
Well-tuned advice with Indexes, MVs
SQL &
Schema

28
 Automatic Memory Tuning

OS Memory • Automatically adapts to

OS Memory
workload changes
DB Shared • Maximize memory utilization
Memory • Single dynamic memory
parameter
DB Shared • Helps eliminate out-of-
Memory memory errors
DB Process
Memory
DB Process
Memory

29
 <Insert Picture Here>

Simplify Systems
Simplify Your Information Infrastructure For Maximum Agility and
Lowest Cost!
Old Pre-Grid Infrastructure
DSS DSS
Standby
HR HR
Standby
Finance 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 10g Database Grid

HR Financials DSS

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: Off-Site
DR-RO
Physical Standby
Database
Sync or Async

• Reporting Production
Database
Redo Shipping Queries

Redo Apply
Backup
DIGITAL DATA S TORAGE

• Read only Physical Standby

Network
DIGITAL DATA S TORAGE

Broker

• Online Upgrades Additional

Reporting Logical Standby Materialized
Indexes &

• Transient Logical Standby

Transform Views
Database
Production Redo to SQL Open for
Reports

• Testing SQL
Apply

• Snapshot Stanby
• Backups QA - Test
Transform
Physical/ Snapshot Standby
Database
Redo to SQL

• Fast incremental backups

Open for
Testing

• Major performance enhancements too SQL

Apply
Changes
queued

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

39
Flashback for Rapid Recovery from
Human Error

Flashback
Flashback Flashback Flashback Data Archive
Query Tables Database and
Transaction

40
 <Insert Picture Here>

Enhance Performance
Major New Performance Innovations
Advanced Compression
in Oracle Database 11g
 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 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
Redo Logs
Standby
Backups

44
 Structured Data Compression
For 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 Compression
Oracle 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
 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.

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 2x faster

48
 Advanced Compression
in 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

50
 Major New Performance Innovations

• TimesTen
• 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 (AutoNFS)
• 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 • XML DB
• Transparent tablespace and • Binary XML storage
LOB Encryption • Enhanced XML indexing
• Business Intelligence • Schema evolution
• OLAP integration with • interMedia
materialized views • Comprehensive DICOM medical
• Simplified Data Mining imagery support
• Integration • 3X faster image processing
• Faster Gateways • Spatial
• New mainframe Gateways • 3D support
• Distributed Scheduler • Improved maps

53
 Application Development Highlights

• PL/SQL • Application Express

• Automatic compilation • Microsoft Access application
• Java and JDBC migration
• Automatic JIT compilation • Reporting – BI Publisher
• “Like JDK” ease of use • Flash charting
• Declarative “Ajax” support
• Windows and .NET
• WYSIWYG editing
• Vista support
• Windows backup (VSS) • SQL Developer
• Version Control
• PHP
• Visual Query Builder
• Database Resident
• Migration Workbench
Connection Pool integration

54
 Other Oracle Database 11g 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 Propagation • Preferred read for geo clusters
• Flashback Transaction
• Manageability and Diagnosability
• One step duplicate DB or create standby
• Automatic Health Monitoring
over the network
• Security • PL/SQL
• Fine-grained dependency tracking
• Secure By Default
• Dynamic SQL enhancements
• Comprehensive Enterprise Manager support
• Performance analysis aids
• Business Intelligence
• Content Management
• Comprehensive Enterprise Manager support
• Storage & Query of Semantic Content (RDF,
• PIVOT/UNPIVOT operators OWL)
• Secure Enterprise Search connectors
• Text improvements

55
Q&
A
QUESTIONS
ANSWERS

56