Enterprise Applications
Product Family
– Contracts, Corporate Performance Management, Customer
Relationship Management, Financials, Human Resources, Interaction
Center, Intelligence, Maintenance Management, manufacturing,
Marketing, Order Management, Procurement, Product Lifecycle
Management, projects, Sales, Service, Supply Chain Planning, Supply
Chain Management
Oracle Ebusiness Suite
online document available
Infrastructure Software
A Brief look at Oracle‟s Database
History
Oracle 7
– Oracle Parallel Server
Oracle 8i
– Transition to Real Application Clusters begins
Oracle 9i
– Integrated Data Warehousing
– Real Application Clusters
Oracle 10g
– New grid capable features
Federated Database
A logical unification of
distinct databases
Independent servers
No shared resources
(including disk)
Connected by LAN
Shared Disk Architecture
Equal access to all
disks
No notion of data
ownership on any node
Managed by Oracle‟s
Real Application
Clusters (RAC)
Shared Disk Architecture: Scalable
Nodes can be dynamically added and
removed from the grid
Adding and removing nodes does not
require data to be redistributed
Multi-version read consistency model
Based upon Real Application Clusters
Multi-Version Read Consistency
Writers never block readers and readers never block
writers
Data is tracked by a System Change Number (SCN)
Always provides consistent and accurate results
Non-escalating row-level locking
– Locks are contained at the row level
Example: System Change Number
Shared Disk Architecture: Availability
The loss of a cluster node does not cause a
loss of data
The loss of a cluster node does not cause
another node to “take over” data
Processes can be redistributed to other
nodes
Traditional Shared-Disk Clustered
Databases
Maintaining data coherency is a hard
problem
– Need to synchronize updates to shared data
– The disk is the only medium for data sharing
Disk I/O latencies appear in the critical path
when multiple nodes access shared data
Disk-based coherency is the main bottleneck
to achieving a scalable shared disk cluster
– Only synthetic fully partitioned workloads scale!
Oracle Real Application Clusters
(RAC)
An application transparent clustered database
– single node applications run and scale with no
changes
Cluster interconnect fabric replaces the disk
as the medium for inter-node data sharing
Cache Fusion protocol for data sharing results
in a scalable cluster for OLTP and DSS
workloads
Oracle RAC
Architecture
Centralized Application Servers/ Users
Management Network
Console
Low Latency Interconnect
No Single
High Speed
Switch or
Point Of Failure
Interconnect
Clustered
Database Instances
Hub or
Switch Storage Area Network
Fabric
Drive and Exploit
Mirrored Disk Industry Advances in
Subsystem Clustering
What is Cache Fusion?
The underlying technology that enables RAC
Protocol that allows instances to combine
their data caches into a shared global cache
– Global Cache Service (GCS) coordinates sharing
Key features are
– Direct sharing of volatile buffer caches
– Efficient inter-node messaging framework
– Fast recovery from node failures using cache and
CPU resources from all surviving nodes
Data Sharing Problem
Read Sharing for Queries
– query needs to read a data block that is currently
in another instance‟s buffer cache.
Write Sharing for Updates
– update needs to modify a data block that is
currently in another instance‟s buffer cache.
With Cache Fusion, a disk read is performed
only if the block is not already in the global
shared cache
Cache Fusion Read Sharing
Uses Oracle‟s Consistent Read (CR) scheme
– undo is applied to make a block transactionally
consistent to a System Change Number (SCN).
– a CR copy is shipped to the requesting instance
1
Query 225 Data Block
SCN 200 2
3
200 CR Copy
Instance A Instance B
Cache Fusion Write Sharing
Multiple dirty copies of a data block can exist
in the global cache, but only one is current
The current copy can move between
instances without first being written to disk
– Changes are logged if not already on disk
Non-current dirty copies can directly service
queries from any node and instance recovery
Cache Fusion Write Sharing
Instance A Instance B
4
Update Current
Block 10 225
3
1 Master 2
Copy
225
Requester GCS Holder
200
Instance C
Efficient Inter-Node Messaging
Messaging cost independent of cluster size
– At most 3 nodes involved in a request
requester, holder and master (directory)
number of messages to service a request is bounded
Inter-Node Message Latency
– exploits high performance interconnect substrates so that
on-the-wire message transmission times are minimal
Frequency of Inter-Node Synchronization
– adaptive directory migration based on access patterns
– fast reconfiguration of resources when a node joins/leaves
Oracle Grid Computing Goals
Storage Database Application Grid
Grid Grid Grid Control
Half the Cost
Highest Quality of Service
Easiest to Manage
Problem with Today‟s IT
Infrastructure
Islands of Computing
Resource
– Some are melting
down
– Some are almost idle
High Costs CRM
– Hardware ERP
– Labor
– Software
Hard to Align
with Business
Priorities
DW
Solution: Computing On Demand
Mainframe Model Grid Computing Model
Partitioning of one large Coordinated use of many
server small servers
Built with high quality, Built with low cost, standard,
high cost parts modular parts
Complete, integrated Open, Complete, integrated
software software
High quality of service at High quality of service at
high cost low cost
Early Grid Computing
Desktop Grids
– SETI@home
Scientific Research Grids
– Globus Toolkit, CERN
What about Grids for the Enterprise?
11
Requirements for Enterprise Grids
Run all your applications
Stores all your information
Highly scalable, available, reliable
Secure
Easy to manage
– Make individual systems self-managing
– Manage thousands of servers at once
Introducing Oracle 10G
Runs all your applications
Stores all your information
Highly scalable, available,
reliable
Secure
Easy to manage
– Make individual systems
self-managing
10G 10G
– Manage thousands of
servers at once
Oracle Database 10G –
The First Database
Designed for the Grid
Orders of MAGNITUDE…
~354 NEW 10g features *
@5 slides / feature *
@2 minutes /slide
= 4.5 DAYs [ 9 hour/day ]
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Oracle Database 10G –
Align Storage with the Business
Problem: Islands of
storage
– “My storage is 50%
utilized
and growing 30% a
CRM
year”
ERP
DW
Oracle Database 10G –
Align Storage with the Business
Problem: Islands of storage
– “My storage is 50% utilized
and growing 30% a year”
Solution: Groups of
standard, modular disks
– Consolidated,
Networked Storage
– Dynamically Provision
Oracle Grid Storage Management
Highly Available and Low Cost
Oracle Automatic Storage
Management
– Manages disk storage groups
– Mirrors, Stripes, Re-balances
– Huge reduction in labor cost
Built-In Data Protection at
Lowest Cost
– Disk Based Backup and
Recovery
Automatic Storage Disk Based
– Flashback in Time Management Backup &
– Site Recovery Recovery
Automatic Storage Management –
Dynamically Provision and Tune
Storage
Portable, high performance
file system
Eliminates need for
conventional file system and
volume manager
Automatic mirroring
Automatic I/O tuning
– Stripes data across disks to
balance load
The Operational Stack
TODAY ASM
Tables Tables
Tablespace Tablespace
0010 0010 0010 0010 0010
Files 0010 0010 0010 0010 0010
Files
File System File System ASM
Logical Vols Logical Vols
Disks Disk Group
“The best way to lower mgmt costs is to remove complexity”
ASM Disk Groups
A pool of disks managed as a
logical unit
Partitions total disk space into
uniform sized megabyte units
ASM spreads each file evenly
across all disks in a disk
group
Coarse or fine grain striping
based on file type
Disk groups integrated with
Oracle Managed Files
Disk Group
ASM Disk Groups
• Administer disk groups not files
• Number of disk groups remains
constant while number of files
and disks continually increases
Fast Disk Group Slow Disk Group
Mirroring with ASM
Failure Groups
Storage resources organized into
Disk Groups and Failure Groups
A Disk Group is a collection of disks
managed as a logical unit in which ASM
files are stored
Controller 1 Controller 2
Disk Groups assigned by DBAs
A Failure Group is a set of disks sharing
a common resource whose failure
needs to be tolerated
– Redundant copies of an extent are
stored in separate Failure Groups
Failure Groups assigned by DBAs or
Failure Group 1 Failure Group 2
automatically by ASM
Disk Group 1
Automatic Storage Management –
Lowest Labor Cost
8
7 7
8
6 6 6
7
6
5
5
Nbr Steps
4
4
3
2 2
2
Traditional
1 0 0 ASM
0
Install Add Storage Remove Migrate Tune I/O Manage
Storage Storage Space
ASM Delivers Great Performance
with no Manual Tuning
22,648
24000
20000
20,590
16000
TpmC
12000
8000
4000
0
ASM (24 Disks) VxVM (24 Disks, 12 s)
Automatic Storage Management -
Mission Critical, Low Cost Storage
for Enterprise Grids
Mission-critical
– Integrated mirroring
– Add/drop disk online
– Best I/O performance
Easy
– Automatic I/O Tuning
– Up to 50% less DBA/Sys Admin work
Low Cost
– Works well with inexpensive disks
– Better storage utilization
Oracle DB 10G Stores All Your Data
Complete Relational
Characters, Numbers and Dates
Integrated
Oracle Text
Text management and search
Oracle interMedia
Multimedia management
Oracle Locator
Location and Proximity Searching
XML DB
Integrated Native XML Database
OCS Files
Low-cost and Easy
41
Oracle DB 10G ULDB - Stores
ALL Your Data
Database size limit raised to millions of
Terabytes (8 Exabytes)
Ultra Large Data Files – Terabytes in
single file
Unlimited size LOB columns – Terabytes
Automatic Storage Management removes
file system limits
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Align Processing with the Business
Problem: Islands of
computation
– “My servers are 15%
utilized“
CRM
ERP
DW
Align Processing with the Business
Problem: Islands of
computation
– “My servers are 15%
utilized“
Solution: Groups of
industry standard
servers
– Lowest cost, highest
performance
– Capacity on demand
– Not Self-healing,
Disposable
Oracle Database 10G RAC
Capacity on Demand for the Grid
Only Cluster
Database that runs
Real Applications and
Scales ERP CRM DW
Highly Available
Runs on standard,
low cost servers
Proven
– Hundreds of
customers
– Certified with
leading apps
Automatic Workload Management
Order Entry Spare Supply Chain
Normal Server Allocation
Automatic Workload Management
Order Entry Supply Chain
End of Quarter
Oracle Database 10G RAC -
Complete, Integrated Clusterware
Complete Oracle cluster
software solution
Single-vendor support
Low Cost
– No need to purchase
Services Framework
additional software Cluster Control/Recovery
– Easy to install, manage Messaging and Locking
Connectivity
High quality and functionality
across all platforms
Common event and
management API‟s
Support for third-party
clusterware
Benefits of Integrated Clusterware
Lower software cost
Easy
– Deploys in hours not days
– Single integrated target for cluster
management provides improved single
system image
Less Risk
– Same high functionality and quality across
platforms
– Single vendor support
Automatic Server Provisioning
Push-button add/drop server to cluster
Hands-free allocation and re-allocation of
servers to services
– Automatic routing of service requests to
appropriate server with lowest load
– On server failure, automatic re-allocation of
surviving servers to services
Works across all platforms
Oracle RAC 10G - Only Solution for
Enterprise Grids
Mission Critical Quality of Service on
Industry Standard, Low Cost Servers
Complete, Integrated Oracle Clusterware
Runs all Applications
Provides Capacity on Demand
RAC Made Easy for Everyone
Automatic Server Provisioning
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Low Cost Fault Tolerance
Computer
Failures
Unplanned
Downtime Data
Failures
System
Planned Changes
Downtime
Data
Changes
Low Cost Fault Tolerance
Computer Oracle10G RAC
Failures Integrated
Unplanned clusterware
Downtime Data – Integrated, less
Failures moving parts, better
tested
Faster failover
System between servers
Planned Changes – Single digit seconds
Downtime
Data
Changes
New Economics for
Data Protection & Recovery
Computer
Failures
Unplanned Disk-Based Recovery
Downtime Data
Failures
Trade cheap disk space
for expensive downtime
System
Planned Changes
Downtime
Data
Changes
56
Flashback Database
New strategy for point-in-time
Old recovery
Disk Write Block Flashback Log captures old
New Version versions of changed blocks
Block – Think of it as a continuous
Version backup
Flashback Log – Replay log to restore DB to time
– Restores just changed blocks
It‟s fast - recovers in minutes, not
hours
Like a “Rewind” button It‟s easy - single command
for the Database restore
– SQL> Flashback Database to
„2:05 PM‟
Flash Backup
Fully automatic disk-
based backup and
recovery
– Set and Forget
Nightly incremental
backup rolls forward
recovery area backup
– Changed blocks are
Database Area Recovery Area Tape tracked in production
DB
– Dramatically faster
Nightly Apply Weekly (20x)
of Archive to Use low cost ATA disk
Incremental Tape array for recovery area
Backup
Oracle Database 10G Highest Data
Protection for Lowest CostData Guard
Redo
Shipping
Flash Backup Site Failure
Protection
On Disk
Flashback Backups
Corruption
Flashback Logs
Protection
ASM Mirroring Human Error
Protection
Storage Failure
Protection
No Cost System Changes
Computer Goal
Failures
Allow any change to
Unplanned
Downtime the system with no
Data
Failures downtime
System Online Reconfiguration
Planned Changes
Rolling Upgrades
Downtime
Data
Changes
60
Oracle10G High Availability Features
Backup and Recovery Backup and Recovery Data Guard (Cont) Flashback
– Automated Disk- (Cont) – Fine-Grained – Flashback Database
Based Backup and – Incrementally Supplemental – Flashback
Recovery Updated Backups Logging Reinstantiation
– Drop Database – Simplified Recovery – Named Data Guard – Flashback Standby
– RMAN Database Through Resetlogs Configurations Database
Deregistration – Restore Tolerates – Simplified Zero Data – Flashback Table
– Backup of Standby Corrupt or Missing Loss for Data Guard – Flashback Row
Control File Backups SQL Apply History
– Automated TSPITR – Full Database Begin – Zero Downtime – Flashback Drop
Instantiation Backup Command Instantiation for SQL – Flashback
– Simplified Recovery – Change-Aware Apply
Transaction History
Manager Cataloging Incremental Backups – Real Time Apply
of Backup Files Redo Data and Online Operations
Data Guard –
– Enhanced Online
– Automated Channel Archivelog
– Data Guard Broker Compression Redefinition
Failover for Backup Support for RAC – Improved Handling of
and Restore
– Automated LogMiner DDL Locks on Busy
– Automated File Configuration
Creation During Tables
Recovery – Log Miner Support for – Signature-Based
Index-Organized Dependency Tracking
– Simplified Backups to Tables
Disk Using Synonyms
– Secured Redo – Rolling Upgrades
– Proxy Copy Backup Transmission
of Archivelogs with Data Guard SQL
Apply
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Oracle Database 10G Ease of
Management
Self-Managing
Database
OEM Grid Control
– Grid-wide
operations
– Scale from one to
hundreds of
systems with little
incremental cost
Business Challenge –
How to Scale DBA‟s to the Grid ?
Installation
6%
Creation &
Others
Configuration 12 %
15%
Software Data
Maintenance 6% Loading 6%
Ongoing System
Management 55%
Source: IOUG 2001 DBA Survey
Oracle10G System Management –
Built-In Intelligent Infrastructure
Automatic Workload
Repository
– Automatically collects
statistics, SQL workload,
Feature usage
Automatic Maintenance
Tasks
– Pre-packaged, resource
controlled
Server-Generated Alerts
– Out-of-the-box, Push vs.
Pull, Just-in-time
Oracle10G System Management –
Automatic SGA Management
Only 2 memory
Online Large Batch Buffer Cache parameters
Users Buffer Cache Jobs Advisor helps
set parameters
Large Pool
Large Pool Automatically
resizes with
SQL Cache SQL Cache
changes in
SGA Pool workload
Java Pool Java Pool
Maximize usage
PGA Pool
sort sort
of available
memory
Oracle10G System Management –
Self Optimizing SQL Management
Oracle Query Optimizer – Proven Technology
– Comprehensive set of access paths, adaptive search
strategy
– All cost-based transformations
– Preconfigured task to collect object and system statistics
– If no statistics available, are collected at parse-time
Automatic memory allocations, automatic degree of
parallelism
Automatic identification and capture of high-load
SQL
– Automatic SQL Tuning
– Automatic SQL Analysis
– SQL Access Advisor
Oracle10G System Management –
Self Optimizing SQL Management
High-load Automated capture
SQL
Packaged
Applications
Custom
Applications
and identification of
high-load SQL
Optimizer Automatic SQL
Tuning
Auto SQL Auto SQL Access
Tuning Analysis Advisor Automatic SQL
Analysis
SQL Indexes &
Profile
SQL Advice
MVs SQL Access Advisor
Packaged Custom Custom
Applications Applications Applications
Well-tuned
SQL
Oracle10G System Management –
Automatic Database Diagnostic Monitor
Performance expert
in a box
Automatically
provides database-
wide performance
diagnosis, including
RAC
Pinpoints root cause
and non-problem
areas
Runs proactively
Enterprise Manager 10G Grid Control
Management that Scales to the Grid
Central management for the complete
platform
Dramatically lower operations costs
Application service level management
Manage one or many systems with little
incremental cost
Scalable Software Maintenance –
Discover and Analyze Configurations
Complete inventory of all Oracle software
– Versions
– Patch levels
Oracle product configuration details
Search and compare configurations
Change tracking
Reference configurations
Scalable Software Maintenance -
Automated Software Cloning
Reduce manual labor in software life-cycle
– From hours to minutes
Automate mass provisioning of reference
systems
Select Software (and 2 Clone to
1 Selected
Instances) to Clone
Targets
3
Update
Inventory
Scalable Software Maintenance -
Automated Patch Management
Real-time discovery of new patches
– Security patch rapid deployment dramatically reduces
vulnerabilities
Automatic staging and application
– From hours to minutes
Rolling RAC upgrade
2 Determine
Applicability
3 Apply Patch
4
Update
1 Patch Published
Inventory
Oracle10G Manageability Features
Infrastructure Server Configuration Instance Tuning Application Tuning
– Easy OracleJVM – Automated Storage – User-Initiated Buffer Cache – SQLAccess Advisor
Monitoring Management Flushing – Materialized View Tuning
– SYSAUX Tablespace Configuration – Database Resource Manager API
– – Automated RAC Services - Adaptive Consumer Group – SQL Tuning Advisor
Enhanced Wait Model
– Database Features Usage Configuration Mapping – Enhanced SQLAccess
– Simplified Upgrade for – Database Resource Manager
Tracking Advisor
– Enhanced Database Time RAC and OPS Databases - Fixed CPU Quota – Automatic Optimizer
– Automated Enterprise – New Performance Overview
Model Statistics Collection
– Manager Configuration Charts in Oracle Enterprise
Top Consumers
– Manager Backup and Recovery
Performance Monitoring & Automated Portable – Enhanced RMAN Reporting
Clusterware Installation – Improved SQL Reporting
Diagnostic – Backup Compression
– JDBC: End-to-end – Automated Configuration Using Oracle Enterprise
Manager – Bounded Backup Window
Java/J2EE Tracing of Recovery Area
– – Integration of Resource – Manage RMAN Scripts
– SQLJ: End-to-end Out-of-the-box LDAP
Java/J2EE Tracing Configuration Manager and Profiles – Recovery Area Full Alert
– – Automated Checkpoint
– Automated Routine Simplified Initialization
Tuning
Storage Management
Administration Tasks Parameters – Multiple Default Temporary
– – Transaction Rollback &
– Proactive Server-based Easy Upgrade Tablespace Support for
Alerts and Notifications – Upgrade Information Tool Recovery Monitoring
SQL Operations
– Database Performance
– Database Statistics and – Simplified Database Install – Automated Storage
Workload Respository –
Analyzer
User Default Tablespace Management
– Redo Logfile Sizing Advisor
– Threshold-Based Alerts – Rename Tablespace
– Automated SGA Memory
Tuning
Oracle10G Manageability Features
(continued)
Network Management Space, Object, Database Utilities Scheduler
– Back Up Directory Naming Transaction Mgmt – SQL*Plus - SPOOL – Core Scheduler Features
– Automatic Undo Retention CREATE, REPLACE, and – Usability and
Entries to Local Naming
File Tuning APPEND Options Manageability
– – SQL*Plus - Show Recycle –
– Dynamic Connection Segment Shrink Advisor Monitoring
– Segment Size Estimation Bin – Recovery
Manager Configuration –
– Online Segment Shrink SQL*Plus - – Support for Jobs in a
– Easy Connect Naming
–
DBMS_OUTPUT After Clustered Environment
Method Proactive Tablespace SELECT
Management – Job Processing
– Easy OCI/JDBC Install – SQL*Plus - SET
– Undo Advisor – ILMS Support
– Improved Network Outage SQLPROMPT Runtime
Variable Substitution – Increased Throughput
Detection –
– SQL*Plus - Redo Minimization
– Automated LDAP COMPATIBILITY – Dynamic Slave Pool
Discovery for Clients Command Line Option
– Improved Connection – SQL*Plus - Run glogin.sql
Manager Access Rules and login.sql After Each
– Automated Shared Server CONNECT
Configuration – iSQL*Plus Input
– Simplified Shared Server Prompting
Configuration Parameters
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Transportable Tablespaces –
Fastest Way to Provision Data
Oracle can unplug and plug database data
files
– Move and share data without unload and
reload
– Plug/unplug performance independent of
tablespace size
– Mount read-only tablespaces on multiple
databases
New: Now Works Cross-Platform!
24
Oracle10G Data Pump
High performance import and export
– 60% faster than 9i export (single thread)
– 15x-20x faster than 9i import (single thread)
Scales with parallel threads
Network transfer data between databases
with no intermediate representation
Oracle Streams Oracle
Oracle Streams moves or copies
tablespaces faster than FTP
Detach, move, attach
with one command
Same platform or cross platform
Oracle Streams Oracle
Oracle Streams moves or copies
tablespaces faster than FTP
Detach, move, attach
with one command
Same platform or cross platform
Oracle Streams Oracle
Oracle Streams moves or copies
tablespaces faster than FTP
Detach, move, attach
with one command
Same platform or cross platform
Optionally stream
delta updates
Migrate to the Grid with
the self-propelled database
Oracle Database 10G–
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Business Intelligence on the Grid
Lower Cost
– Leverage 10G hardware, software, labor savings
– Manage millions of terabytes
Intelligence when you need it
– Real-time data feeds and integrated BI capabilities
More value from your data
– Additional integrated BI capabilities
Managing Large Volumes of Data
Partitioning and parallelism are crucial for VLDB
Partitioning provides „incremental‟ operations for:
– WORK SMARTER
– Data loading, Indexing, Referential Integrity
– Backup and Recovery
– Queries
Parallelism for all operations
– WORK HARDER
– DBA operations: loading, index-creation, table-creation, data-
modification, backup and recovery
– End-user operations: Queries
– Unbounded scalability: Real Application Clusters
Partitioning - Minimal Unit of Work
Intelligent usage of partitioning information is key
success factor for availability
– Partition Pruning
– Backup and Recovery
– Read-Write versus Read-Only
order table
jan99 feb99 mar99 apr99 may99
Partitioning - Rolling Window
Partition level management
– Range, Composite (range + hash), List
– On-line addition and removal of partitions
– Data management operations (loading, index builds)
Improved availability
– Localized disk failures, backup and recovery
order table Add
jan99 feb99 mar99 apr99 may99
Drop
Local Index
Other data is not affected
Table Compression
Table Compression increases:
– I/O-subsystem capacity
– I/O throughput
– query scan performance
– buffer cache capacity
Table Compression:
– reduces cost of ownership
– is easy to use
– requires little or no table definition changes
– is transparent to applications
Table Compression:
What is it?
Tables can be compressed
– Compression can also be specified at the partition level
– Indexes and index-organized tables are not compressed
Typical compression ratios are 3:1 - 6:1
– Compression is dependent upon the actual data
– Compression algorithm based on removing data redundancy
All DDL/DML commands are supported on compressed
tables
Oracle Parallel Query - Scanning
Data is Partitioned into
Scanner #1 Granules (block range or
partition)
Each Scanner is Assigned
Multiple Granules
No two scanners ever
Scanner #2 contend for the same granule
Granules are assigned so
that the Load is Balanced
Across all Scanners
Dynamic Granules
Scanner #3
...
10G Real Time Warehouse
Asynchronous CDC
Logical DW
Based on Change Data Tables
Archived Streams
log
files Transform
SQL, PL/SQL,
Java
SQL interface to change data
Publish/subscribe paradigm
Parallel access to log files, leveraging
OLTP Oracle Streams
DB Parallel transformation of data
Oracle10G Business Intelligence
Features
Real Time Data VLDB Summary Management OLAP
Warehousing – Bigfile Tablespace – Summary Management – Parallel AGGREGATE
– Asynchronous Change – Enhanced Partition OLAP Query Performance Command
Data Capture Management in Enterprise Improvements – Parallel SQL IMPORT
– Manager – Summary Management - Command
Cross-Platform
Transportable – Global Partitioned Indexes Enhanced Partition-aware – PL/SQL Creation of
Tablespaces - Hash Partitioning Materialized View Refresh Analytic Workspaces
– – – Summary Management - –
Enhanced Table Partitioned Index- Intra-Dimensional
Functions Organized Tables - List EXPLAIN PLAN Shows (Attribute) Aggregation
– External Tables Unload Partitioning Materialized View Access – Enhanced Composite
– – Summary Management -
– Enhanced MERGE Partitioned Index- Dimensions Indexing
Functionality Organized Tables - LOB Enhanced Dimensions – PL/SQL OLAP Measure
Support – Summary Management -
– Data Pump Export and Calculation Definition
Import Utilities – Partitioned Index- Nested Materialized View – Complete Analytical
– Organized Tables - Global Refresh Workspace Management
Parallel Data Pump Export –
and Import Index Maintenance Summary Management - – Multi-Writer Support
–
– Enhanced Bitmap Index Enhanced PCT Refresh –
SQL*Loader Direct Path – XML Interface for Analytic
Load Support for ROWID Performance and Space Summary Management - Workspace
Datatype Management Query Rewrite Uses
–
– Local Partitioned Indexes Multiple Materialized
SQL*Loader Direct Path
Load Support for VARRAY Manageability
Datatype Improvements
– SQL*Loader Direct Path
Load Support for
XMLType Tables
Oracle10G Business Intelligence
Features (Continued)
Data Mining Bio-informatics
– – DOUBLE and FLOAT
Frequent Itemsets
– Datatypes
Attribute Importance – BLAST Queries
Algorithms
– Statistical Functions
– Enhanced Adaptive Bayes –
Network Document Clustering
– Document Clustering Non-
– JSR-73 RI & TCK - Java negative Matrix
Data Mining Factorization
– Multi-User Access Control – Document Clustering
– Complete Oracle Data Neural Nets
Mining Management – Document Named Entity
– Enhanced Model Seeker Extraction
– Support Vector Machines
– PMML Producers /
– Taxonomy Builder
Consumers
– Enhanced Data SQL Analytics
Preprocessing – Grouped Table Outer Join
– – Increased Number of
Data Mining Rapid
Application Development Aggregates per Query
– SQL Interrow Calculations
– Upsert Through SQL
Interrow Calculations
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Application Development on the Grid
HTML DB
– Low Cost, Hosted,
Web Based
Development
Environment
Improved PL/SQL
Performance
Database Web
Services
HTML DB and the Grid - Business
Problem
Departmental and
LOB data sharing and
information tracking
Lots and lots of
desktop databases
Fragmented
Inaccurate
Untimely
Vulnerable
HTML DB – Perfect for the Grid
Productivity of a
Desktop Database
Infrastructure of an
Enterprise Database
Built for the Web
Leverages the Grid
Oracle Database 10G –
Database for the Grid
Storage for All Your Data
Real Application Clusters
High Availability
Ease of Management
Data Provisioning across Grid
Business Intelligence on the Grid
Application Development on the Grid
Oracle Database 10G
Half the Cost
– Low cost hardware with high utilization
– Integrated software stack
– Self-managing
Highest Quality of Service
– Highest Performance, Scalability,
Availability, Reliability, Security
Easy to Align with Business Priorities
Oracle Database 10g Performance
Metrics
PLSQL up to 2x Incremental backup up 10x
Table Scans up to 2x Parallel media recovery
SQL Profile Tuning 2-4x
huge Backup compression 17x
Floating point math up Infiniband interconnect
to 10x ½ latency, 2x block
transfer
Bulk LOB Update up to
TPC-C
3x – Best absolute and best on 4-
Import up to 15x way Intel
– +28% on same hardware
Export up to 35%
Q U E S T I O N S
A N S W E R S