4 facing explosive data growth five ways to optimize storage for oracle database environments


Safe Harbor Statement

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.

<Insert Picture Here>

5 Ways to Optimize Storage for Database Environments

Eric CW Chan Principal Sales Consultant, Oracle Systems Hong Kong

18 October 2013


More

Data Sources

Consumers

Data Reuse

Virtualization

Long Retention

Drivers

More

Capacity

Performance

Complexity

Management

Risk

=

Drivers Storage Impact

Explosive Data Growth


Application Engineered Storage

• Superior Performance

• Unrivalled Efficiency

• Lower Risk

• Unsurpassed Economics



Tape

1. Data Protection

2. Throughput

3. Latency

4. Storage Footprint

5. Tuning and Management


5 ways to optimize

Tape

Maximize data protection


A Comprehensive Approach to Data Protection

User Error

Management Error

Forgetfulness

Malicious Behavior

Software Error

Storage Media Error

Storage System Failure

Data Center Outage


One Solution Does Not Meet All Requirements Differences in Organization Size and Risk Intolerance

Data Loss (Recovery Point Objective)

Downtime (Recovery Time Objective)

Hrs Mins Secs Wks Days Hrs Mins Secs Wks Days


• Oracle Exadata Storage Expansion

• ZFS Storage Appliance

• Pillar Axiom

• StorageTek Tape Storage

• Tiered Storage

Oracle Database Data Protection

• Archive Log Mode

• Oracle Data Guard

• Flashback

• Data Recovery Advisor

• RMAN

• Built in Backup and Recovery Tools

• Snapshots

• Boot Environments

• OVM Backup

• Oracle Enterprise Manager Operations Center

• Oracle Enterprise Manager

• Oracle Secure Backup

Tools


5 Ways to Optimize


Improve throughput for Data Warehouses


Pay More for Less Performance with NetApp

• 136% faster than

2-node NetApp

FAS6240

• Even 73% faster

than 4-node

NetApp FAS6240

• 109% faster than

2-node NetApp

FAS3250

2-4x Faster, 2x Less Space AND 2-4x Less Expensive

Double The Productivity of Your Data Center


Highest Large DB/DW Performance World Record Performance on SPC-2

Speed and Value Drive the Productivity of Your Data Center


5 Ways to Optimize

Tape



Minimize latency for OLTP


Minimize Latency

56-node EMC Isilon delivers ~ IOPS

(but 3x slower latency) as a 2-node

Oracle ZS3 Storage system

IOP

S

Late

nc

y

DC

Sp

ac

e

Po

wer

443,0

00

<1m

s

<1 R

ack

42,8

40 B

TU

/hr

IOP

S

Late

nc

y

DC

Sp

ac

e

Po

wer

456,0

00

3m

s

5 R

ack

84

,00

0 B

TU

/hr

Speed Your OLTP Workloads


5 Ways to Optimize

Tape

Shorten backup windows, maximize data protection



Reduce storage footprint


Shrink Storage Requirements with HCC

10x to 15x

Data Compression

Ideal for: Data Warehousing,

Database ILM, DR, Test/Dev

3–5x Less Disk Space

3–5x Less Energy Used

3–5x Lower Cost

Oracle Database 11g R2 Enterprise Edition and later

on Any Server, No Additional Charge

Oracle Database with Hybrid Columnar

Compression

ZFS Storage Pillar Axiom


Oracle Database 12c Automatic Data Optimization Heat Maps and Usage Patterns Drive Auto-Tiering


ORACLE DATABASE 12C AUTOMATIC

DATA OPTIMIZATION converts less frequently

changed data to HCC formats

Only with Oracle Storage

Only Oracle Storage Automates Compression

This Quarter

UNCOMPRESSED for fast OLTP

OLTP

3X

This Year

OLTP

HCC Query for Fast Analytics

HCC Data

10x

Uncompressed Data

Prior Years

Compliance and Reporting

HCC Archive for Maximum Compression

HCC Data

15x

Uncompressed Data


5 Ways to Optimize

Tape

Shorten backup windows, maximize data protection



Reduce storage footprint

Streamline storage tuning and management


IO metadata details exchanged with

ZFS Storage Appliance

Oracle ZS3 Storage System

Oracle Intelligent Storage Protocol (OISP) Virtually Eliminate Manual Tuning for Oracle Database

Oracle Database 12c

ZFS Storage Appliance Dynamically Tunes Critical Storage Parameters

Dynamic Storage Tiering

1TB

DRAM

2+PB

DISK

READ

Flash

WRITE

Flash


DTrace Analytics for Administrative Efficiency

Only storage system with real-time, dynamic application-aware performance and health analytics

Visualize CPU, cache, protocol, disk, memory, networking, and system-related data, all at the same time

44% faster troubleshooting for deeper understanding, more quickly

Cut administrative costs by up to $27,000 per system per year by switching from NetApp to Oracle’s ZFS Storage

Gain Control of Your Data Center


Unique Performance and Customer Value

Oracle

Storage

Systems

Oracle

Database

Data Reduction

Simpler Storage Management

Higher Performance

Streamlined Deployment

Higher Application Availability


Competitor Filer Sprawl Means 252% More in Hardware and

Software Costs

Other Costs 136% More for Operations and

Maintenance

Optimize and Save Competitor Costs 266% More to Own and Operate

Save Your Resources



Tape

• Ensure data integrity and availability

• Accelerate time to insight

• Enable faster customer transactions

• Reduce storage costs

• Streamline and simplify management

Value to Your Business


More Info & Paper at www.oracle.com/storage

4 facing explosive data growth five ways to optimize storage for oracle database environments

Technology

oracle andor

confidential oracle

sole discretion of oracle

oracle systems hong

data warehouses11copyright

data center13copyright

storage footprint

node netapp fas6240double