Oracle Exadata V2

Sun Oracle Database MachineExtreme Performance. Simplified Deployment.

• Extreme performance for…– Data Warehousing

– OLTP

– Consolidation

• Simplified deployment…– Pre-configured systems

– Industry-standard hardware

– Oracle Database 11g Release 2

• Extreme value…– Best price/terabyte

– Best price/performance

Sun Oracle Database MachineMassively Parallel Grid

Oracle Database 11g Server Grid

• 8 database servers

• 64 Intel cores

InfiniBand Network

• 40 Gb/sec

• Unified server / storage network

Exadata Storage Server Grid

• 14 storage servers

• 100 TB (SAS) or 336 TB (SATA) raw disk

• 5 TB flash storage

Extreme PerformanceFor all database applications

• Unique software capabilities…– Smart Scan – Query processing within storage

– Smart Flash Cache – I/O acceleration

– Compression – I/O and storage reduction

– Partitioning and Storage Indexes – I/O elimination

– Infiniband – Fastest network available

– Oracle Database 11g – #1 database performance

• Unique performance…– #1 in I/O throughput – Up to 65 GB per second*

– #1 in I/O rate – Up to 1 million I/O’s per second

– #1 in compression – 3x to 15x data compression

Sun Oracle Database MachineSoftware Components

Oracle Database 11g

• Real Application Clusters

• Partitioning

• Advanced Compression

• Advanced Security

• OLAP

• Data Mining

• In-Memory Parallel Queries

• Enterprise Manager

• Automatic Storage Management

• Data Guard / Active Data Guard

Exadata Storage Server Grid

• Smart Scan

• Smart Flash Cache

• Hybrid Columnar Compression

• Storage Indexes

Data Warehouse Bandwidth Problem

• Can’t ship data to Database servers fast enough

Solving the Data Bandwidth Problem

• Wider pipes and more of them

• Reduce data going through the pipes

Exadata Storage ServersHardware by Sun, Software by Oracle

• Exadata Storage Server Hardware

– 2 Intel quad-core Nehalam processors

– 12 SAS or SATA disk drives

– Dual 40Gb InfiniBand connections

– 4 96GB Flash cards

• Exadata Storage Server Software

– Oracle Database 11g Release 2

– Oracle Enterprise Linux

– Exadata smart storage

9

Exadata Smart StorageAddressing data bandwidth bottleneck

• Massively parallel high performance storage grid

– Scales performance and data bandwidth with data volume

– 40 Gb InfiniBand provides maximum bandwidth

• Exadata Storage Servers run data intensive processing

– Queries run in storage as data streams from disk

– Offloads processing from database server processors

• Exadata Hybrid Columnar Compression

– Reduces data volume up to 10x

– 10x lower cost, 10x higher performance

Query Processing:The problem with traditional storage

What Were

Yesterday‟s

Sales?

SUM

Oracle Database Server Grid Storage Array

Retrieve Entire

Sales Table

Select sum(sales) where

salesdate= „22-Dec-2009‟ …

Query Processing: Using Oracle Exadata Storage Server

What Were

Yesterday‟s

Sales?

SUM

Oracle Exadata Storage Grid

Select sum(sales) where

salesdate= 22-Dec-2009‟ …

Retrieve Sales for Dec 22 2009

Oracle Database Server Grid

• Data stored by column

and then compressed

• Useful for data that is bulk

loaded or moved

• Query mode for data warehousing

– Typical 10X compression ratios

– Scans improve accordingly

• Archival mode for old data

– Typical 15- 50X compression ratios

Oracle Exadata Storage ServerHybrid Columnar Compression

50XUp To

13

Benefits MultiplyData is 10x Smaller, Scans are 2000x faster

1 TB

with compression

10 TB of user data

Requires 10 TB of IO

100 GB

with partition pruning

20 GB

with Storage Indexes

5 GB Smart Scan on

Memory or Flash Subsecond

Best Data Warehouse MachineConsolidating data and analytics

Data Mining

Integrated ETL Online Analytics

Industry Data Models

15

“Every query was faster on Exadata compared to our current

systems. The smallest performance improvement was 10x and

the biggest one was an incredible 72x.”

Simeon Dimitrov, Enterprise Resources Manager

“Call Data Record queries that used to run for over 30 minutesnow complete in under 1 minute. That's extreme performance.”

Grant Salmon, CEO, LGR Telecommunications

“A query that used to take 24 hours now runs in less than 30 minutes. The Oracle Database Machine beats competing

solutions on bandwidth, load rate, disk capacity, and transparency.”

Christian Maar, CIO

World‟s Fastest Data Warehouse Machine

Query Throughput Comparison

7.510

21

50

0

5

10

15

20

25

30

35

40

45

50

GB

/Se

co

nd

(u

nc

om

pre

ss

ed

)

TERADATA2550

NETEZZATwinFin 12

SUN ORACLEDatabase Machine

DiskDisk

Disk

Flash2x – 5x

better

throughput

Storage Price Performance

SUN ORACLE Database Machine

TERADATA

2550

NETEZZA

Twinfin 12

SAS Disks SATA Disks

Total Disk

Storage100 TB 336 TB 42 TB 96 TB

User Data

Capacity140 TB @ 10x

compression

500 TB @ 10x

compression

12.6 TB @ 1.43x

compression

72 TB @ 2.25

compression

System Price $1,150,000 H/W

$1,680,000 S/W*$819,000 $1,480,000

Price per User TB $20,000 $5,700 $65,000 $20,000

Price per GB/sec

of query thruput$55,000 $110,000 $150,000

* Use your existing database licenses, full list price for Storage Server Software

18

World‟s Fastest OLTP MachineUnique OLTP capabilities

• Runs business applications “on the Grid”– Oracle eBusiness Suite

– Oracle Peoplesoft

– Oracle Siebel

• Fault-tolerant, scale-out Database Servers– Real Application Clusters

– Data Guard

– Online operations

• Fault-tolerant, scale-out Storage Servers – Automatic Storage Management

– Exadata Storage Servers

19

Exadata Storage ServersDramatic new OLTP capabilities

• SUN Flashfire Storage

– 4 x 96GB cards in every storage server

– 5TB in SUN Oracle Database Machine

• 10x better I/O response time

• 20x more random I/Os

• Greatly reduced cost

– 10x fewer disks needed for I/O

– Lower power required

20

First Flash Optimized DatabaseExtreme performance for random I/O

• Huge semiconductor memory hierarchy

– 400 Gigabytes DRAM

– 5 TB Smart Flash Cache – not Flash disk!!!

• 1 Million random I/Os per second

– Eliminates most physical disk I/O

• 3x database compression for OLTP

– Compressed 1.2 TB Database in DRAM

– Compressed 15 TB Database in Flash Cache

Maximum Availability ArchitectureProtect from planned & unplanned downtime

• Protection from unplanned failures

– Server failures

– Storage failures

– Network failures

– Site failures

• Protect from planned downtime

– Human error correction

– Online indexing and table redefinition

– Online patching and upgrades

• Remote standby open for queries

Oracle Database Security Defense in Depth

Monitoring

Access Control

Encryption & Masking

Sun Oracle Database MachineConsolidate Database Applications

• Flexible Capacity

– Grid architecture for scaleout of database and storage servers

– Smart Scan query offloading

– Smart Flash Cache for real-time random I/O

– Data compression for OLTP, Warehousing and Archival data

– Infiniband networking to support massive data transfers

• Resource Sharing

– Automatic Storage Management shares storage across all databases

– Real Application Clusters shares databases across many servers

– I/O Resource Management prioritizes I/O bandwidth

– Instance Caging shares CPU for multiple databases within a server

• All the power of Oracle Database 11g

Consolidate on the CloudOracle „Private Cloud‟ Grid Infrastructure

Database Machine

consolidates:

Database Servers

Storage Servers

Application

Servers

Scalable Choice of Configurations

Quarter Rack

Half Rack

Full Rack

Multi Rack

What Customers Think?

Oracle Exadata V2

• Fastest Data Warehousing

& OLTP Performance

• Best Data Warehousing

& OLTP Cost/Performance

• Fault Tolerant

& Scalable On-Demand