a5 oracle exadata-the game changer for online transaction processing data warehousing and...

Oracle Exadata - The Game Changer for Online Transaction Processing, Data Warehousing and Consolidation

Anthony Au-Yeung

Principal Sales Consultant

Oracle Systems Hong Kong

Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 2

The following is intended to outline our general product

direction. It is intended for information purposes only, and

may not be incorporated into any contract. It is not a

commitment to deliver any material, code, or functionality,

and should not be relied upon in making purchasing

decisions. The development, release, and timing of any

features or functionality described for Oracle's products

remains at the sole discretion of Oracle.


Exadata Database Machine

Designed to be the best platform for Oracle Database

Integrates and optimizes servers, storage, network

– Using high-volume servers in a scale-out architecture

– Flash-optimized

Special software brings database intelligence to

storage, flash, and networking

– To deliver extreme performance and data compression

Deployments are fast, reliable, and supportable

Optimal for all database workloads

– OLTP, Data Warehousing, and Database Clouds


Exadata Evolution

• Exadata V1

Introduced

• V2 Servers

• 40 Gb InfiniBand

• PCI Flash Cards

• X2-2 Servers

• X2-8 64-core Servers

• Sparc SuperCluster

• 3TB Disks

• Smart Flash Cache

• Storage Index

• Columnar Compression • Smart Scan

• InfiniBand Scaleout

• Enterprise Manager 12c

Database to Disk

Management

• Hardware DB Encryption

• Automatic Service Request

• Data Mining Offload

• Storage Expansion Rack

• X2-8 CPU Refresh

• 2TB DRAM per node

• Solaris x86

• Reverse Offload

• Smart Flash Logging

State-of-the-Art,

Scale-out Hardware

Unique Software

Integration

2008 2009 2010 2011 2012



• Write-back

Flash cache

2013

• Oracle 12c

support

• 11gR2 &

12c co-

existence


1000’s of Deployments at Leading Companies 50% Data Warehouses | 50% Consolidation/Mixed Workloads


Exadata Scale-Out Platform Complete Platform for Running Database – Servers, Storage, Networking

Scale-Out Database Servers

• 8x 2-socket servers 256 GB DRAM each or

• 2x 8-socket servers 2 TB DRAM each

Scale-Out Intelligent Storage Servers

• 14x 2-socket storage servers

• 168 disk drives – 500TB

• 56 Flash PCI cards – 22 TB Flash

High Speed Network

• Unified InfiniBand internal connectivity ( 40 Gb/sec )

• 10Gb or 1Gb Data Center connectivity

Fully Redundant


Scalable Capacity From Eighth Rack to Multi-Rack

X3-2 Eighth Rack 16 compute cores

512 GB memory

18 storage cores

2.4 TB flash memory

23 TB usable disk

X3-8 Full Rack 160 compute cores

4 TB memory

168 storage cores

22 TB flash memory

224 TB usable disk

Multi-Rack

Database

Machine

Exadata

Storage

Expansion

Racks


Exadata Data Processing Transformations Extreme Performance at Lowest Cost

+ + +

• Hybrid Columnar Compression – Faster Analytics

– Huge Space Savings

– 10x compression for warehouses

– 15x compression for archives

Space Savings

Cascade to

Database Copies

compress

primary DB

uncompressed

• Smart Scale-Out Storage – InfiniBand connected servers

– Smart Scan query offload

• Smart Scale-Out PCI Flash

Caching – Accelerates I/O up to 30x


Exadata Intelligent Storage Grid

• Data Intensive processing runs in Exadata Storage Grid

• Filter rows and columns as data streams from disks (168 Intel Cores)

• Example: How much product X sold last quarter

• Exadata Storage Reads 10TB from disk

• Exadata Storage Filters rows by Product & Date

• Sends 100GB of matching data to DB Servers

• Scale-out storage parallelizes execution and removes bottlenecks

100GB/sec

Data

Throughput


Exadata Hybrid Columnar Compression Highest Capacity, Lowest Cost

• Data is organized and compressed by column

• Dramatically better compression

• Speed Optimized Query Mode for Data Warehousing

• 10X compression typical

• Runs faster because of Exadata offload!

• Space Optimized Archival Mode for infrequently accessed data

• 15X to 50X compression typical

Qu

ery

Faster and Simpler

Backup, DR, Caching,

Reorg, Clone Benefits Multiply


Exadata Smart Flash Cache Write-Back

Caches Write I/Os in PCI flash in addition to Read I/Os

Transparently accelerates write intensive workloads

– 20X more write IOPS than disk on X3

– 10X more write IOPs than disk on V2 and X2

Persistent write cache speeds database recovery

Exadata Flash Cache is much more effective than flash

tiering architectures used by others

– Caches current hot data, not yesterday’s

– Caches data in granules 8x to 16x smaller than tiering

Greatly improves the effectiveness of flash

Writes I/Os

1 Million 8K

Write IOPs

from SQL


Comprehensive protection from failures

Server – Storage – Network – Site – Corruptions

Active Disaster Recovery: Real-time standby open for query offload

Correction from human errors: database, table, row, transaction

Online indexing and table redefinition

Online patching and upgrades

WAN

Real

Application

Clusters

ASM

RMAN / Fast

Recovery

Area

Active Data Guard

/ GoldenGate

Secure

Backup

Primary

Standby Dev/Test

Maximum Availability Architecture Mature and Proven at Thousands of Customers


Exadata I/O Resource Management Mixed Workloads and Multi-Database Environment

• Ensure different databases are allocated correct resources

• Database A: 33% I/O resources

• Database B: 67% I/O resources

• Ensure different users and tasks within a database are

allocated the correct resources

• Database B:

• Interactive: 60% of I/O resources

• Batch: 40% of I/O resources


Enterprise Manager 12c End-to-End Hardware + Software management for Exadata

• Performance, availability,

usage by databases, services,

clusters

• Software and hardware alerts

• Topology view of DB

systems/cluster

• Drill down from database issue

to hardware root cause


Customer Use Cases


Exadata for SAP Customers Across all Industries


Rapid Growth & Cost Reduction

• German based company in the electrical industry

• €1.52B revenue with 12,300 employees worldwide

Company Background

• Large SAP systems, fast growth , exploding DBs

• Complex hardware/software components & IT operational costs need reduced

Challenges

• Took 25 days to go live in Jan 2012

• Delivered 13-14x faster BI queries

• ECC reports run 9x faster

Engineered Systems Impact for IT Department

• Reduce monthly close by one day!

• Stable in peak demand times

• Online eBusiness SLAs now met even at peak

Business Transformation

http://www.oracle.com/us/solutions/sap/custstory-exa4sap-autode-1595194.pdf


Improve Performance & Cost Reduction

• Swiss based, leading commodities producer/marketer with US$ 186 billion

• Operates 24x7, 50 offices in 40 countries Company Background

• Minimizing the infrastructure's complexity

• Consolidating SAP and non-SAP systems

• Increase System availability

Challenges

• Planned downtime dramatically reduced

• Reduced administration overhead

• One vendor for IT infrastructure

Engineered Systems Impact for IT Department

• Reports that used to be generated overnight now appear on the user’s screen within an hour.

• Exadata pays off in all subsequent activities

Business Transformation

http://www.oracle.com/us/solutions/sap/custstory-exa4sap-glencore-1595191.pdf

19

Paypal - Largest OLTP database on Exadata

• Fast paced VLDB OLTP environment on Oracle

– 500+ database instances

– OLTP databases commonly 10-130 TB

– 5,000-14,000 concurrent processes

– 80,000 executions/second, 10GB Redo/Minute

• Continuously growing

– High growth of PayPal’s business up to 2 X workload

– Tier one databases built to support 300K execs/sec to support Q4

PayPal's Critical Application Architecture

20

GoldenGate Real-time Data Integration *

Extreme Performance

• 300K executions/sec

• Real Time analysis of 99.99% of

critical transactions.

• avg 40 ms response for 95%

• < 200 ms response for 99.99%

HA and MAA

•99.99% Availability

•MAA technologies (RAC, ASM,

ADG, Exadata, Flashback, GG)

• All disk groups using high

redundancy

•Active Data Guard for auto block

corruption repair and DR

•Rolling upgrade using ASM,

Exadata, CRS, Data Guard, and

GoldenGate

Mission-critical

Databases

Primary Data Center

DR Data Center

Data Guard ASYNC Redo Transport

ETL

Targets Production Databases • 2 X Exadata X2-8

• 2 X Full Storage Expansion

Active Data Guard Standby • Offload queries and reads

• Corruption Protection

• Symmetric System

WAN, 650+ miles (30ms)

Test/Dev

Production and Standby Clusters = 8 Exadata Racks

3 identical Architectures = 24 Exadata Racks + Test/Dev Resources supporting our Critical Applications.


U.S. Customs and Border Protection

Business Objectives

• Reduce cost and complexity

• Meet availability SLAs

• Extreme scalability

• Consolidation

Solution

• 2010: Implement V2, X2-2

• 2011: Add X2-2, X2-8

• 2012: Add X2-8, Exalogic

Benefits

“Oracle Exadata has changed our strategic IT focus

from building systems to developing and

supporting application services critical to the

fulfillment of our national security mission.”

- Ken Ritchhart, Deputy Assistant Commissioner

Exadata X2-2

Primary /Standby

Exadata X2-8

Primary/Standby

Exadata V2

Primary/Standby

Automated Targeting

Systems

Automated Export

Systems

Passenger

Systems

Enterprise Data

Warehouse

2010 2011 - 2012 2010 - 2011

Storage

Savings

1 Petabyte

Replaced $$ SAN

Faster

Applications

10X speedup

32 billion queries/day

Cost

Savings

75% Cost

Reduction

Maximum

Availability

99.95%

Data Guard Data Guard Data Guard


Turkcell: DW and DB Consolidation

Business Objectives

• Speed up BI

• Lean, green data center

• Prepare for big data growth

Solution

• 2010: Replace 11 racks with

1 full-rack Exadata V2 for DW

• 2011: Add 2 full-rack Exadata

X2-2s for DB consolidation

2 Exadata X2-2

Prod

Original V2

Prod/DR/Dev

Exadata V2

Data Warehouse

Pre-Exadata

Data Warehouse

Hitachi

USP-V

5 Racks EMC DMX-4

5 Racks 2011

• 250 TB

Raw Data • 2 Prod Databases

• 600 TB Raw / 60 TB

Compressed

• 16-node RAC Cluster

• 25 TB

Compressed

Benefits Reduced

Admin

20%

Storage

Savings

900 TB

1,000 TB to 100 TB

Faster

Reports

10X

27 min to 3 min

(avg for 50k rpts)

“In a word, Oracle Exadata is fantastic. Almost no

report takes more than 10 minutes to run, versus

hours before. It sounds unreal, but it’s real.”

- Power User, Finance Department, Turkcell

80% Less Power

30 m2 Less Space

Data Center

Cost Savings

• 4 Prod, 2 Test

Databases

• 400 TB Raw/

40 TB Compressed

• 2 RAC Clusters

2010 Backup Restore


SK Telecom: Revenue Assurance DW

Exadata X2-2

Qtr Rack (2010)

• Spam Filtering

Business Objectives

• Ensure billing accuracy

• Enhance customer service

• Predict data traffic trends

Solution

• 2009: Create new DW on Exadata

V1 half-rack

• 2010: Move to full-rack Exadata V2

• 2011: Add full-rack Exadata X2-2

2010 2011

Exadata V2+X2-2

Data Warehouse

• 1,000 TB Raw / 100 TB

Compressed

• 16-node RAC Cluster

Exadata V2

Data Warehouse

• Billing Analysis

System

• Usage & Roaming

Inquiries

Exadata V1

Data Warehouse

(2009)

• Billing Analysis

System

Benefits Storage

Savings

900 TB

1,000 TB to 100 TB

$ Millions

Capture Lost

Revenue

Extreme

Capacity

10 TB/day “Oracle Exadata Database Machine has overwhelmingly superior

performance, with average data processing rates 8 to 20 times

greater than other SK Telecom in-house systems.” - Jin-hyung Lee, Manager, Network Engineering Department, SK Telecom


Garmin: OLTP Consolidation

Exadata V2

DB Consolidation

Pre-Exadata

12 Prod Servers

2012

• Oracle E-Business Suite

• Advanced Supply-Chain

Planning

• Hyperion Reporting

• Garmin Connect custom app

Business Objectives

• Add fault tolerance

• Reduce costs via

standardization

• Simplify support model

• Performance & Scalability

Solution

• 2012: Consolidate 12 servers

onto two Half-rack Exadata

V2 systems

Data Guard

Exadata V2

Dev/Test/Local Standby

• 5 Prod

Databases

High-Capacity

Exadata Storage

Servers

• Archived

Data

• Tape backup

Benefits 4x Growth Faster

Month End Reports

Up to 11X

99.95%

Uptime

Data Center

Cost Savings

“Oracle Exadata helped us meet our challenges by

enabling us to consolidate to a single footprint.”

- Ed Link, Vice-President IT, Garmin


P&G: DW and Mixed Workload

Business Objectives

• Improve stability and supportability

• Lower costs

• Boost performance

Solution

• 2010: Implement 1ST DW on V2

• 2011: Move 2nd DW to X2-2,

Move OLTP/Analytics to X2-2

• 2012: Move 3rd DW to X2-8

Benefits Simplified

Support

Faster

Applications

2 - 30X “Performance with Exadata is much better, and getting an

out-of-the-box solution dramatically reduced the time

and money to build and maintain our DW platform.”

- Brian Beckman, DW Platform Manager, Procter & Gamble

Exadata V2

Data Warehouse Prod Non-Prod

• Trade/Mkt/POS Data

Exadata X2-2

Data Warehouse Prod DR Dev UAT

• Shipments Data

Exadata X2-8

Data Warehouse Prod Non-Prod

• Fin’l/Planning Data

Exadata X2-2

OLTP/Analytics

Data Guard

• Trade Fund

Management

Storage

Savings

3x – 10x

Compression

Prod Non-Prod


Exadata Database Machine Vision

Best Platform for…

• Data Warehousing

• OLTP

• Database Cloud

OLTP with Analytics and

Parallelism of Warehousing

Warehousing with Interactivity,

Availability, and Security of OLTP


Graphic Section Divider

a5 oracle exadata-the game changer for online transaction processing data warehousing and...

Technology