5 database features every dba needs to know about tht11267 doug chamberlain - principal product...

5 Database Features Every DBA Needs to Know AboutTHT11267

Doug Chamberlain - Principal Product Manger, Oracle

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 3

Safe Harbor StatementThe 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.

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 4

How are there 5

things you don’t know?


~1 out of 10Report that storage limits database and application performance a significant amount (over 25% of the time)

YET the majority are NOT compressing, tiering or using advanced storage visibility tools

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 6

The Top Five…Smarter Approaches to Alleviate Stress

Partitioning – Granular Control of Your Database

HCC – Massive Space Savings Plus Speed Gains

ADO with Heat Maps – Dynamic ILM and Compression

Direct NFS – Network Speed and Simplicity

OISP – Database-Aware Storage Automation

1

2

3

4

5


5% Active95% Less Active

ORDERS TABLE (10 years)

High End Storage Tier

2004

Simple Yet Powerful; Transparent to ApplicationsPartition for Tiered Storage

2014

Low End Storage Tier 2-3x less per terabyte

2013








1

2

3

4

5


Hybrid Columnar Compression

• Up to 50x space reduction• Average 5x faster queries• Only available on Oracle storage

– Exadata Storage Servers– ZFS Storage Appliance– Axiom Storage

• Increases performance for most data warehouse and data protection

Store Less Data AND Run Faster

735GB 38GB

1

2

3

0

1

2

3

0

2 Hours, 22 Min, 44 Sec 16 Min, 50 Sec

8xFasterQuery

94%LessStorage

UncompressedWith Hybrid Columnar

Compression

Retail Data Warehouse Example








1

2

3

4

5


Oracle Enterprise Manager 12c Heat Map• “Heat Map” tracking

– Database level shows which tables and partitions are being used

– Block level shows last modification at the block level

• Comprehensive– Segment level shows both reads

and writes– Distinguishes index lookups from

full scans– Automatically excludes stats

gathering, DDLs or table redefinitions

Active

Frequent Access

Occasional Access

Dormant

Actively updated

Infrequently updated, Frequently Queried

Infrequent access for query and updates

Long term analytics & compliance

HOT

COLD


ORACLE DATABASE12C AUTOMATIC

DATA OPTIMIZATION converts less frequently

changed data toHCC formats

Only with Oracle Storage

Automatic Data Migration with ZS3 and Hybrid Columnar CompressionOnly Oracle Automates Tiered Compression

This QuarterUNCOMPRESSEDor ACO Row Storefor fast performance

Active

This Year

Analytics

HCC Query forFast Analytics

HCCData

10x

UncompressedData

Prior Years

Compliance and Reporting

HCC Archive forMaximum Compression

HCCData

15x

UncompressedData








1

2

3

4

5


Direct NFS Architecture

Database NAS StorageDirect NFS client

…LGWR I/O queue

…DBWR I/O queue

…PQ slave I/O queue

…RMAN I/O queue

LGWR TCP connection

DBWR TCP connection

PQ slave TCP connection

RMAN TCP connection

Direct NFS can issue 1000s of concurrent

operations due to the parallel architecture

Every Oracle process has its

own TCP connection

Parallel network paths for scalability

and failover


Why Direct NFS for Primary Storage?

• Lower CAPEX networking equipment– 10 Gb Ethernet or 40 Gb Infiniband networking options

• Simplified Management and Provisioning– IP based network management skill set– DBAs or Sys Admins can manage without Storage Admin– Reduced man hours reduces operating expenses

• High Performance– Direct NFS is optimally designed and tuned for

Database workloads– Superior performance to kernel NFS or iSCSI– Performance comparable to Fibre Channel

High Performance with Simplified Management and Reduced Costs

50 200 4000.0%

20.0%

40.0%

60.0%

80.0%

100.0%

120.0%

102.3% 99.1% 100.6%

Relative Order Entry Performance

TPS 10GbE dNFS TPS FC

Number of Users








1

2

3

4

5


Oracle Intelligent Storage Protocol• Database and Storage Co-engineering

– Intelligence is in the code within both the database and storage

– Available ONLY with Oracle Database 12c and Oracle ZFS Storage Appliance OS 8 and above

• Storage Awareness of Database Workload– Database sends cues about each IO to the

storage– Over 70 database IO types mapped– Information used by storage to adaptively

and automatically adjust for optimal efficiency


“OISP is like a Bat Phone to the Mayor’s office while everyone else is on rotary dial.”

– Dave Vellante, Analyst, Wikibon


Summary

• Smarter Approaches to Database Storage Exist TODAY• Save time, money and stress with:

– Partitioning – Granular Control of Your Database – HCC – Massive Space Savings Plus Speed Gains– ADO with Heat Maps – Dynamic ILM and Compression– Direct NFS – Network Speed and Simplicity– OISP – Database-Aware Storage Automation

• Application Engineered Storage

5 database features every dba needs to know about tht11267 doug chamberlain - principal product...

Documents

oracle andor

storage performance

database storage

storage limits database

storage admins

storage matters

storage layer

application performance