Corporate PPT Template

1
(No Transcript)
2
Andrew MendelsohnSenior Vice President
Database Oracle Corporation
3
Oracle Database 10gA Revolution in Database
Technology
4
Oracle 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

5
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
6
Grid 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

7
Oracle Grid Computing
Coordinated use of many small servers acting as
one large computer.
8
Reducing 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

9
Introducing Oracle 10g

• Complete, integrated grid infrastructure

10
Introducing
11
Oracle Grid Computing

• Highest quality of service
• Lowest cost
• Easiest to Manage

12
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
• Stripes data across disks to balance load
• Best I/O throughput
• Automatic mirroring
• Easy

Automatic Storage Management
13
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
• Stripes data across disks to balance load
• Best I/O throughput
• Automatic mirroring
• Easy

Automatic Storage Management
14
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

15
Storage Grid - Highest Data Protection for Lowest
Cost
16
Database 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
17
Cost savings as much as 25-50 in hardware and
maintenance were real and undeniable.

• Gartner

Source Gartner Early Adopters Experiences with
Oracle9i RAC, Nov 2003
18
Database 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

19
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)

20
Grid 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

21
Low 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
22
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

23
Oracle 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

24
Business 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
25
Oracle 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

26
Sophisticated Simplicity.

• Infoworld

Source Infoworld.com, March 22, 2004
27
Oracle has clearly gone farther than any other
vendor to instrument the database and provide
expert advice to administrators.

• Charlie Gary, Meta Group

Source Source META Group Oracle 10g Managing
Reality, December 17, 2003
28
Oracle OEM 10g Grid Control

• Manages the Oracle Grid environment
• Scales to thousands of servers
• Application Service Level Management
• Configuration Management
• Provisioning
• Cloning
• Patch Management

29
We now can manage hundreds of servers throughout
the world from within one powerful management
console.

• Warwick CalkinNational Manager, Telstra IT
  Infrastructure and Operations

30
Business 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

31
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

32
Oracle 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

33
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
34
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

35

The best thing about the Grid is that it is
unstoppable. The Economist June 2001
2
36
(No Transcript)