Oracle Database Reliability, Performance and scalability on Intel Xeon platforms Mitch Shults, Intel Corporation October 2011

(1)

1 Oracle Database Reliability,

Performance and scalability

on Intel Xeon platforms

Mitch Shults, Intel Corporation

October 2011

(2)

2 Up to 10 Cores and

20 Threads

30MB of on-die

cache

Up to 2 Terabytes of

DDR3 Memory

1 and low voltage

DIMM support

Advanced

Encryption

Standard –

New Instructions

Intel® Trusted

Execution

Technology

Intel

®

_Xeon

®

_Processor

E7-8800/4800/2800 Product Families

1 On 4S system using 32 GB DIMMS

All dates, product features and plans are subject to change without notice.

(3)

3 Oracle and Intel Co-Development Cycle

ARCHITECTURE

and

INFRASTRUCTURE

HARDWARE

SOFTWARE

XEON

COMPLETE

COMPILERS

and

TOOLS

SYSTEM

DESIGNS

OPERATING

SYSTEM

ENABLEMENT

DATABASE

OPTIMIZATION

MIDDLEWARE and APPs

OPTIMIZATION

Firewall

(4)

4 Developed using Intel

®

_{Compilers and Libraries}

• Speeds up compression and decompression of data

• Increases overall throughput and performance

Optimized Encryption for Enhanced Security

• Strong protection of data in transit with Oracle Advanced Security

using Intel

®

_IPP

• Use of AES-NI to deliver more efficient encryption and decryption

Advanced Reliability Features (RAS)

• Machine Check Architecture Recovery

• Error Containment

• Corrected Error Signaling

(5)

5 4-socket systems can…

…process the biggest workloads…maximize consolidation

…increase system uptime…handle highly variable workloads

Large Workloads

& Max. Consolidation

Highly Variable Workloads

Mission Critical Class System

Availability

Over

2X

the compute performance across a

range of benchmarks

1

Up to

7X

memory capacity for greater

performance, headroom and memory DIMM

savings

2

Up to

2X

higher consolidation

3

More performance headroom to handle peak, unexpected,

or underestimated workloads

Compute, memory and I/O scalability extends useful server

life in high-growth workloads

Denser compute resources per server maximizes

performance in constrained sites

Protects your data by preventing errors

Increased availability via healing, redundancy

and failover technologies

Minimized downtime via failure prediction and

proactive replacement of failing components

Intel

®

_Xeon

®

_{Processor E7-4800 Product Family vs. Xeon}

®

_{Processor 5600 Series}

4S Servers Make Good Business Sense

1. Results have been estimated based on internal Intel analysis and are provided for informational purposes only. Any difference in system hardware or software design or configuration may affect actual performance. For more information on performance tests and on the performance of Intel products, visit http://www.intel.com/performance/resources/limits.htm

2. 64 DIMM slots vs. 18 slots for the Xeon 5600 processor series platform

3. 2X higher consolidation refresh ratio based on ROI tool comparing Xeon 7500 and Xeon 5600 vs.. older generations.

Software and workloads used in performance tests may have been optimized for performance only on Intel microprocessors. Performance tests, such as SYSmark and MobileMark,

are measured using specific computer systems, components, software, operations and functions. Any change to any of those factors may cause the results to vary. You should

consult other information and performance tests to assist you in fully evaluating your contemplated purchases, including the performance of that product when combined with other

products.

(6)

6 2005

2005

2006

2007

2008

2010

2011

Intel® Xeon® Processor Historical Performance

Source: Intel internal OLTP database workload performance estimates as of 15 April 2011. Results have been estimated based on internal Intel analysis and are provided for informational purposes only. Any difference in system hardware or software design or configuration may affect actual performance.

2005 Xeon 3.66GHz = 64-bit Intel® Xeon® Processor 3.66 GHz, 1M Cache, 667 MHz FSB 2005 Xeon 7041 = Intel® Xeon® Processor 7040 (4M Cache, 3.00 GHz, 667 MHz FSB) 2006 Xeon 7100 = Intel® Xeon® Processor 7140M (16M Cache, 3.40 GHz, 800 MHz FSB) 2007 Xeon 7300 = Intel® Xeon® Processor X7350 (8M Cache, 2.93 GHz, 1066 MHz FSB) 2008 Xeon 7400 = Intel® Xeon® Processor X7460 (16M Cache, 2.66 GHz, 1066 MHz FSB) 2010 Xeon 7500 = Intel® Xeon® Processor X7560 (24M Cache, 2.26 GHz, 6.40 GT/s Intel® QPI) 2011 Xeon E7-4800 = Intel® Xeon® Processor E7-4870 (30M Cache, 2.40 GHz, 6.40 GT/s Intel® QPI)

Dual

Core

90nm

Quad

Core

65nm

Eight

Core

45nm

Ten

Core

32nm

Single

Core

90nm

20x Increase in Database Performance since 2005

Xeon

7040

Xeon

7500

Six

Core

45nm

Xeon

7400

Xeon

3.66GHz

Xeon

E7-4800

Xeon

7300

Dual

Core

65nm

Xeon

7100

(7)

7 Item

Size

CPU Sockets

CPU

Memory

Disks

I/O

UCS C460 M1

4RU

4 Intel Xeon E7-

₄₈₀₀

64 DIMM

512 GB

12 SFF

SAS/SATA

10 PCIe

UCS C260 M2

2RU

2 Intel Xeon

E7-2800

64 DIMM

1 TB

16 SFF

SAS/SATA

6 PCIe

UCS B230 M2

Half

2 Intel Xeon

E7-2800

32 DIMM

512GB*

2 SSDs

1 Mezz

UCS B440 M2

Full

4 Intel Xeon

E7-4800

32 DIMM

512GB

4 SFF

SAS/SATA

2 Mezz

Intel® Xeon® E7 based Cisco UCS Servers

UCS B440 M2

High-Performance Blade Server

Compute-intensive server for

enterprise-critical workloads

UCS B230 M2

Compact, Performance

Blade Server

High-performance,

compact &

memory-intensive server for

virtualized workloads

UCS C260 M2 Extended

Memory Rack-Mount

Server

Large-Memory,

I/O-and-compute-intensive workloads in a 2RU

form factor

UCS C460 M1

High-Performance

Rack-Mount Server

Compute and

memory-intensive server for

(8)

8 Intel Xeon®E7® based Cisco UCS Performance Records

Server World Records

Results as of April 29, 2011

1

_{Two socket comparison based x86 Volume servers—Intel Xeon series and AMD Opteron 6100 Series}

1

_{Four socket comparison based on x86 servers—Intel Xeon series and AMD Opteron 6100 Series}