Transcript Corporate PPT Template

Andrew Mendelsohn
Senior Vice President
Database
Oracle Corporation
Oracle Database 10g:
A Revolution in Database
Technology
Oracle Database 10g Goals
 Half the Cost
 Highest Quality of Service
–
–
Highest Availability, Reliability, Security
Highest Performance, Scalability
 Easiest to Manage
Problem: Islands of
Computation




Limited scalability, no resource sharing
Must be configured for peak loads
Single point of failure
Slow to adjust to business needs
Sales
Files
HR
Procurement
Service
Supply
Chain
Financials
Grid Vision
 Computing as a utility
–
A network of clients and service providers
 Client-side: Simplicity
–
Request computation or information and receive it
 Server-side: Sophistication
–
–
Availability, reliability, security
Capacity on demand, load balancing
 Virtualization
–
–
Nothing more virtual than a utility
Massive potential
Grid Computing Eliminates
Islands of Computation
Coordinated use of many small servers
acting as one large computer.
IT Problem
Separate servers
High h/w & s/w costs
Configured for peak
Single point of failure
Hard to change
Difficult to manage
Grid Solution
Shared servers
Low cost components
Capacity on demand
Fault tolerant
Flexible
Unified management
Introducing Oracle 10g
Complete, integrated grid infrastructure
Oracle Grid Computing
Storage Grid
Database Grid
Application Server
Grid
Grid
Control




Low cost
Highest quality of service
Rapidly adjusts to meet business needs
Unified management
Automatic Storage
Management (ASM)
 Eliminates need for
conventional file system and
volume manager
 Capacity on demand
–
Add/drop disks online
 Automatic I/O load balancing
–
–
Automatic Storage
Management
Stripes data across disks to
balance load
Best I/O throughput
 Automatic mirroring
 Easy
ASM – How it Works
 No volumes: just a pool of
storage
 Partitions total disk space
into uniform sized
megabyte units
Automatic Storage
Management
ASM – How it Works
 No volumes: just a pool of
storage
 Partitions total disk space
into uniform sized
megabyte units
 Efficient, online add/remove
of disk with automatic
rebalancing
Automatic Storage
Management
ASM – How it Works
 No volumes: just a pool of
storage
 Partitions total disk space
into uniform sized
megabyte units
 Efficient, online add/remove
of disk with automatic load
balancing
Automatic Storage
Management
Automatic Storage
Management Summary
 Low Cost
–
–
–
–




Eliminates need for volume manager and file systems
Works well with inexpensive, modular storage
Better storage utilization
Easy – up to 50% less DBA/Sys Admin work
Fault tolerant
Raw disk performance
Capacity on demand
Automatic I/O load balancing
Storage Grid - Highest Data
Protection for Lowest
Data Guard
Cost
Redo
Shipping
Flash Backup
Flashback
ASM Mirroring
Storage Failure
Protection
Flashback Logs
Human Error
Protection
On Disk
Backups
Corruption
Protection
Site Failure
Protection
Database Server Grid –
Real Application Clusters
 Runs Real Applications
 Proven
–
–
Over 500 production sites
Certified with leading apps
 Runs on standard,
low cost servers
 Fault tolerant
 Capacity on demand
 New integrated clusterware
makes it easy everywhere
ERP
CRM
DW
Database Server Grid Integrated Clusterware Makes
it Easy
 Portable to all platforms
 Low Cost
–
–
No need to purchase additional software
Easy to install, manage
 Easy
–
–
–
Deploys in hours not days
Improved single system image
Single-vendor support
 Remains open to third-party clusterware
Database Server Grid –
Workload Management
 Push-button, online add/drop server to cluster
 Automatic Load Balancing
–
–
–
–
Based on “service” concept
Automatic routing of service connection requests to
appropriate server with lowest load
On server failure, automatic re-allocation of surviving
servers to services
Dynamic load balancing when service levels not met
(coming soon)
Grid Fault Tolerance
Database
Failover
App. Server
Detection
Total
Recovery Time
Oracle9i
10 - 60 secs
minutes
minutes
Oracle 10g
< 8 secs
< 4 secs
< 12 secs
Re-establish database connections faster
with Oracle 10g infrastructure.
Oracle RAC 10g - Only
Solution for Enterprise Grids
 Mission Critical Quality of Service on
Industry Standard, Low Cost Servers
 Integrated clusterware makes RAC easy
for everyone
 Fault tolerant, scales all applications
 Capacity on demand
 Automatic load balancing
Oracle 10g Grid Management
One-half to one-tenth the cost
 Self-Managing
Database
 OEM Grid Control
–
–
Grid-wide
operations
Scale from one to
hundreds of
systems with little
incremental cost
ERP
EMAIL
DW
Business Challenge –
How to Scale DBA’s to the
Grid ?
Installation
6%
Creation &
Configuration 12 %
Others
15%
Software
Maintenance 6%
Data
Loading 6%
Ongoing System
Management 55%
Source: IOUG 2001 DBA Survey
Oracle Database 10g
Self-managing Database

Built-in Intelligent Infrastructure
–
–

Automatic Database Diagnostic Monitor
–

Automatic performance diagnostic engine in the
database
Automatic Tuning Optimizer
–


Code instrumentation
Data warehouse to analyze performance of customer
workloads
SQL Profile to tune packaged applications
Automatic PGA and SGA Memory Management
Lots more …
Oracle 10g OEM Grid Control
 Manages the Oracle
Grid environment
 Scales to thousands
of servers
 Application Service
Level Management
 Configuration
Management
–
–
–
Provisioning
Cloning
Patch Management
ERP
EMAIL
DW
10g is a Revolution in Oracle
DB Management, Tuning
 Rewrite all the books for Enterprise DBA’s
 A whole new set of books possible for DBA’s
managing “small to medium size” databases
–
Learn all you need to know in 2 Days
Business Intelligence on the Grid
 Lower Cost
–
–
Leverage 10g hardware, software, labor savings
Manage millions of terabytes
 Intelligence when you need it
–
–
Cross-platform transportable tablespaces
Asynchronous change data capture
 More value from your data
–
–
Mature OLAP, Data Mining
Improved SQL Analytics – SQL Model Clause
HTML DB –
Rapid Web Development Tool
 Builds database-driven Web applications
 For non-programmers
 App developers and app users just need a
web browser
 Addresses MS Access proliferation problem
–
Supports hosted development and deployment
environment
10g Performance Metrics




PLSQL up to 2x
Table Scans up to 2x
SQL Profile Tuning huge
Floating point math up to
10x
 Bulk LOB Update up to
3x
 Import up to 15x
 Export up to 35%
 Incremental backup up 10x
 Parallel media recovery
2-4x
 Backup compression 17x
 Infiniband interconnect
½ latency, 2x block transfer
 TPC-C
–
–
Best absolute and best on 4way Intel
+28% on same hardware
Easy Transition to the Grid
 Oracle 10g preserves
investment
–
–
–
Runs all existing apps
on clusters
Moves data to new
platforms as fast as
FTP
Low risk - Start small
and add capacity on
demand
ERP
EMAIL
DW
Oracle 10g Grid Computing
 Half the Cost
–
–
–
Low cost, modular
storage and servers
Complete,
integrated software
infrastructure
Half the labor cost
 Highest Quality of
Service
 Rapidly Adjust to
Business Needs
–
–
Capacity on
demand
Load balancing
 Easy to Manage
ERP
EMAIL
DW
“The best thing about the Grid is
that it is unstoppable.”
The Economist
June 2001
2
Key Technology Innovations
 Automatic Storage
Management
 Flashback
Database/Table
 Fast Disk-based Backup
and Recovery
 RAC Workload
Management
 Rolling Upgrade
 Cross-platform
Transportable
Tablespaces
 Exabytes of data
 SQL Model Clause
 Self-managing
Database
 Grid Control
 HTML DB
 Integrated software
stack
Next Steps….
 Tuesday, 2pm, Larry Ellison, Keynote on 10g
 Wednesday, 9:45 Chuck Rozwat, Keynote on
10g
 Wednesday, 2:30 Ken Jacobs, Keynote on
Ease of Management
Key Technical Presentations











Self-managing DB, Monday, 1 pm, Rm 103
HTML DB, Monday, 1 pm, Rm 104
OEM Grid Control, Monday, 2:30 pm, Rm 103
RAC, Monday, 2:30 pm, Rm 104
SQL Model Clause, Monday, 4 pm, Rm 130
High Availability, Tuesday, 11 am, Rm 304
XML DB, Tuesday, 11 am, Rm 130
Grid, Tuesday, 3:30 pm, Rm 102
ASM, Wednesday, 11 am, Rm 103
Streams, Wednesday, 1 pm, Rm 103
OLAP, Thursday, 1 pm, Rm 131
Reminder –
please complete the OracleWorld
online session survey
Thank you.