1
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
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.
2
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Exadata X3
Database In-Memory Machine
Henry Han
Director, Oracle
3
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle Exadata Database Machine
Best Platform for…
• Data Warehousing
• OLTP
• Database Cloud
Oracle’s strategic platform for ALL
Database workloads
4
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Exadata Architecture
Complete Database platform using standard servers for Compute and Storage
Scale-Out Database Servers
• 8x 2-socket, or 2x 8-socket Xeon database servers
• Oracle Database, ASM, RAC; Linux or Solaris
• Standard Ethernet to data center
Scale-Out Intelligent Storage Servers
• 2-socket storage servers, Exadata Storage Software
• Up to 500 terabytes disk per rack
• 56 PCI Flash memory cards per rack
InfiniBand Network
• Unified internal connectivity ( 40 Gb/sec )
5
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Highly Engineered and Standardized
Less Risk, Better Results
 Hundreds of engineer years spent optimizing and
hardening the system end-to-end
– Frees I/T talent to focus on business needs
 Standard platform improves support experience
 Runs all existing Oracle Database workloads
6
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Superior Database & Exadata Support
ORACLE PLATINUM SERVICES
Complete. Integrated. Proactive.
 24/7 support
 Specialized Engineered Systems Support Team
 2-hour onsite response to hardware issues1
 New Updates and Upgrades for Database,
Server, Storage, and OS software
 My Oracle Support proactive support portal
 "Phone home" automated service requests (ASR)
High Availability. No Additional Cost.
 Better support for the complete Oracle stack
–
Includes higher support levels for Database software
 Proactive remote monitoring for faults
 Industry leading service level response times:
–
–
–
5 Minute Fault Notification
15 Minute Restoration or Escalation to Development
30 Minute Joint Debugging with Development
 Oracle Engineers perform quarterly patching
and updates
Available for recent configurations on Exadata
1 Covered
7
system must be within an Oracle two-hour service area to receive two-hour response as a standard service.
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Key Exadata Innovations
Extreme Performance at Lowest Cost
• Smart Scale-Out Storage
– InfiniBand connected servers
– Smart Scan query offload
+
+
– Transparent cache in front of disk
– Accelerates random I/O up to 30x
– Quadruples data scan rate
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
– 10x compression for warehouses
– 15x compression for archives
uncompressed
+
• Smart PCI Flash Cache
8
• Hybrid Columnar Compression
Data remains
compressed
for scans
and in Flash
Space Savings
Cascade to
Copies
compress
primary DB
standby
test
dev
backup
1000s of Deployments at Leading Companies
Half are Warehouses, Half are OLTP or Mixed Workloads
 Petabyte Warehouses
 SAP, E-business Suite,
PeopleSoft, Siebel, JDE
 Regulatory Reporting
 Online Financial Trading
 E-Commerce Sites
 Consolidation of 100s of
Databases
9
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Exadata Evolution
X2-8 2010
V2 2009
V1 2008
Warehouse
OLTP & VLDB
Smart Storage
Flash
InfiniBand Scale-Out
Columnar
10
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Scale-Up
80-core SMPs
Exadata X3 | Database In-Memory Machine
2012
2010
X3
2009
2008
Warehouse
OLTP & VLDB
Database On Disk
11
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Scale-Up
Massive Flash
All I/Os to Flash
Database In-Memory
Exadata X3 Database In-Memory Machine
 X3 mass memory hierarchy delivers extreme performance
– Automatically moves all active data from disk to memory
2 or 4 TB
DRAM
Hottest Data
22 TB PCI
FLASH
Active Data
 DRAM memory expanded to 2 or 4 TB for hottest data
– 4 to 40 TB of compressed user data
 Flash memory expanded 4X to 22 TB per rack
– 40 to 200 TB of compressed user data – ALL active data
 Comparable to 15,000 disk drives in 150 array frames
500 TB
DISK
– 100 GB/sec SQL data scan rate for reporting and warehouses
Cold Data
12
– 1.5 Million SQL random read I/Os per second for OLTP
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
 Comparable to 1,000 disk drives in 10 array frames
Exadata Smart Flash Cache
Write-Back Cache Accelerates Write Performance 20X
1 Million 8K
flash write
IOPs from
SQL
 New software caches write I/Os in flash memory
– Now all reads and writes of active data go to flash
– 1 Million 8K flash write I/Os per second on an X3 rack
 Comparable to 10,000 disks on 100 array frames
 20X more writes than previous Exadata version
– New software also provides 10x write improvement on
existing V2 and X2 systems
 Cache is persistent and fully redundant
– Also improves database availability by accelerating write
intensive recovery
13
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Exadata Flash Performance Scales Linearly
Storage Array Architecture Limits Flash Performance
Query Throughput
100
Gigabytes per Second
 Exadata scales using
– True Scale-Out
– InfiniBand
– Smart Storage
4 to 13
Storage Array
14
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Exadata
Extreme Performance and Low Cost
 Extreme Performance dramatically lowers cost
– Workloads that require huge traditional systems run on small Exadatas
Disks for Capacity
– Hardware needed for an application is often reduced 10x
 Exadata also delivers Extreme Capacity
Flash for I/Os
– Huge disk footprint for large or less active data
 500 TB of disk per rack for historical data, low activity data,
images, documents, backups, etc.
DRAM for Throughput
Cost of Disk
I/Os of Flash
Speed of DRAM
15
– Columnar compression expands disk and memory capacity 10x
– Blend of tiers gives highest performance at lowest cost
 Placing all data in DRAM would cost $20M just for chips
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Business Benefits of Database In-Memory Machine
 Sub-millisecond latency
– Interactive OLTP with millions of users
Hottest Data
 Sub-second analytics
– Real-time decision making, instant reports
Active Data
 10x faster parallel jobs
– Quarter close, payroll, supply planning,
field inventory, pricing, route planning,
sub-ledger accounting
Cold Data
16
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Exadata Database Cloud
• Exadata has the unique ability to run many databases
supporting multiple workloads in a single cloud platform
– High-end OLTP, Warehousing, batch, reporting, backups, …
– All at the same time
• X3 database in-memory delivers extreme performance for
all workloads
– Also prevents one workload from overloading disks leading
All Workloads, All Applications
SAP, Siebel, PeopleSoft, JDE,
E-business Suite, Fusion
Applications
17
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
to poor performance for all
Exadata X3 Details
Bigger
 Same Architecture as Exadata X2
 Same Price as Exadata X2
All X3 Database Machines
4X Larger Flash Memory
20X More Write Performance
33% More Data Throughput
10% to 30% Lower Power
22 TB of Flash Memory per Rack
Exadata Smart Flash Write Caching
100 GB/sec running SQL
Up to 3 Kilowatt Reduction per Rack
X3-2 Database Servers
33% Faster Database CPUs
75% More Memory
Full 10Gb10%
Ethernet
Data Center
to 20%toLower
Power
18
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
8-Core Xeon® SandyBridge E5-2690
1 TB to 2 TB per Rack
40X 10Gb ports per Rack
Faster
Seamless Upgrades and Expansions
Upgrade Example
X3-2
Half to Full Upgrade
in 2012
X2-2
Qtr to Half Upgrade
in 2011
V2
Initial Quarter Rack
deployed in 2010
19
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
 A single Database Machine can have
servers from different generations
 Databases and Clusters can span
across multiple hardware generations
 New software runs on older hardware
INTRODUCING
EXADATA EIGHTH RACK
X3
20
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
NEW Exadata X3-2 Eighth Rack
Faster Than 2010 Quarter-Rack, 2008 Half-Rack
 Lowest Cost Exadata Configuration
– Hardware List price $200K: 60% of Quarter Rack
Lowest
Cost
– 16 Database Cores, 54 TB Disk, 2.4 TB PCI Flash
– Highly Available configuration with all Exadata features
 Brings Exadata Extreme Performance to smaller
workloads, development, test, disaster recovery
 Hardware Identical to Quarter-Rack
– Half CPU Cores, Disks, and Flash Cards Disabled
– Half the Database and Exadata Software Licenses
 Upgrade to Quarter-Rack with software command
21
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Complete Family of Database Machines
Oracle Exadata X3-2
2, 4, and 8 database nodes
Oracle Exadata X3-8
2 (80 core) database nodes
4 TB DRAM
Eighth
Quarter
Half Full
22
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Multi-Rack
Summary
• 4th Generation Database Machine
• X3 Database In-Memory Machine
• All Active Data in Memory
• Exadata Database Cloud
• New Entry-level Eighth Rack
23
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
X3
24
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
25
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.