Title: Corporate PPT Template
1(No Transcript)
2Andrew MendelsohnSenior Vice President
Database Oracle Corporation
3Oracle Database 10gA Revolution in Database
Technology
4Oracle Database 10g Goals
- Highest Quality of Service
- Highest Availability, Reliability, Security
- Highest Performance, Scalability
- Half the Cost
- Lower hardware, software, labor costs
- Easiest to Manage
5Problem 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
6Grid Computing Eliminates Islands of Computation
Coordinated use of many small servers acting as
one large computer.
IT Problem
Grid Solution
- Expensive Components
- High incremental costs
- Configured for peak
- Single point of failure
- Hard to change
- Difficult to manage
- Low cost, modular components
- Low incremental costs
- Capacity on demand
- Fault tolerant
- Flexible
- Unified management
7Oracle Grid Computing
Coordinated use of many small servers acting as
one large computer.
8Reducing IT Costs
Oracle Grid Computing
Large Dedicated Server
Grid Control
- Expensive components
- High incremental costs
- Configured for peak
- Single point of failure
- Enterprise service at high cost
- Low cost modular components
- Low incremental costs
- Capacity on demand
- Fault tolerant
- Enterprise service at low cost
9Introducing Oracle 10g
- Complete, integrated grid infrastructure
10Introducing
11Oracle Grid Computing
- Highest quality of service
- Lowest cost
- Easiest to Manage
12Automatic Storage Management (ASM)
- Eliminates need for conventional file system and
volume manager - Capacity on demand
- Add/drop disks online
- Automatic I/O load balancing
- Stripes data across disks to balance load
- Best I/O throughput
- Automatic mirroring
- Easy
Automatic Storage Management
13Automatic Storage Management (ASM)
- Eliminates need for conventional file system and
volume manager - Capacity on demand
- Add/drop disks online
- Automatic I/O load balancing
- Stripes data across disks to balance load
- Best I/O throughput
- Automatic mirroring
- Easy
Automatic Storage Management
14Automatic 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
15Storage Grid - Highest Data Protection for Lowest
Cost
16Database Server Grid Real Application Clusters
- Runs Real Applications
- Proven
- Over 1000 production sites
- Certified with leading apps
- Runs on standard,low cost servers
- Fault tolerant
ERP
CRM
DW
17Cost savings as much as 25-50 in hardware and
maintenance were real and undeniable.
Source Gartner Early Adopters Experiences with
Oracle9i RAC, Nov 2003
18Database Server Grid -Integrated Clusterware
- 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
19Database 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)
20Grid Fault Tolerance
Database App. Server Total
Failover Detection Recovery Time
minutes
minutes
Oracle9i Oracle 10g
lt 1 minute
seconds
seconds
seconds
- Fastest end-to-end application failover with
Oracle 10g infrastructure
21Low Cost Servers - HP TPC-C Benchmark
1,184,893
1,008,144
7.9 MTotal Cost
2.6 MTotal Cost
TPM-C
Same 1.5 GHz Itanium2 CPUs
Source http//www.tpc.org - Audited Results
22Oracle 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
23Oracle 10g Grid ManagementOne-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
24Business Challenge How to Scale DBAs to the
Grid ?
Installation 6
Others 15
DataLoading 6
Software Maintenance 6
Ongoing System Management 55
Source IOUG 2001 DBA Survey
25Oracle Database 10gSelf-managing Database
- Built-in Intelligent Infrastructure
- Code instrumentation
- Workload repository
- Automation of Routine Tasks
- Automatic disk-based backup and recovery
- Automatic optimizer statistics collection
- Automatic PGA and SGA Memory Management
- Automatic Storage Management
- Tools to Empower the DBA
- Automatic Database Diagnostic Monitor
- Automatic Tuning Optimizer
- Lots more
26Sophisticated Simplicity.
Source Infoworld.com, March 22, 2004
27Oracle has clearly gone farther than any other
vendor to instrument the database and provide
expert advice to administrators.
Source Source META Group Oracle 10g Managing
Reality, December 17, 2003
28Oracle OEM 10g Grid Control
- Manages the Oracle Grid environment
- Scales to thousands of servers
- Application Service Level Management
- Configuration Management
- Provisioning
- Cloning
- Patch Management
29We now can manage hundreds of servers throughout
the world from within one powerful management
console.
- Warwick CalkinNational Manager, Telstra IT
Infrastructure and Operations
30Business Intelligence on the Grid
- Lower Cost
- Leverage 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
31HTML 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
32Oracle Database 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
- 1.2 million on RAC, 1 million SMP
- Best absolute and best on 4-way Intel
- 28 on same hardware
33Easy 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
34Oracle 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
35 The best thing about the Grid is that it is
unstoppable. The Economist June 2001
2
36(No Transcript)