Transcript THT11267-Five-Database-Features-Every-DBA

5 Database Features Every
DBA Needs to Know About
THT11267
Doug Chamberlain
- Principal Product Manger, Oracle
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
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.
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
3
How are
there 5
things you
don’t know?
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
4
~1 out of 10
Report 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. |
The Top Five…Smarter Approaches to Alleviate Stress
1
Partitioning – Granular Control of Your Database
2
HCC – Massive Space Savings Plus Speed Gains
3
ADO with Heat Maps – Dynamic ILM and Compression
4
Direct NFS – Network Speed and Simplicity
5
OISP – Database-Aware Storage Automation
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
6
Partition for Tiered Storage
Simple Yet Powerful; Transparent to Applications
ORDERS TABLE (10 years)
2004
2013
2014
95% Less Active
Low End Storage Tier
2-3x less per terabyte
5% Active
High End Storage Tier
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
The Top Five…Smarter Approaches to Alleviate Stress
1
Partitioning – Granular Control of Your Database
2
HCC – Massive Space Savings Plus Speed Gains
3
ADO with Heat Maps – Dynamic ILM and Compression
4
Direct NFS – Network Speed and Simplicity
5
OISP – Database-Aware Storage Automation
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
9
Hybrid Columnar Compression
Store Less Data AND Run Faster
Retail Data Warehouse Example
• 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
With Hybrid Columnar
Compression
Uncompressed
94%
Less
Storage
735GB
38GB
0
3
0
1
8x
Faster
Query
2
2 Hours, 22 Min, 44 Sec
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
3
1
2
16 Min, 50 Sec
The Top Five…Smarter Approaches to Alleviate Stress
1
Partitioning – Granular Control of Your Database
2
HCC – Massive Space Savings Plus Speed Gains
3
ADO with Heat Maps – Dynamic ILM and Compression
4
Direct NFS – Network Speed and Simplicity
5
OISP – Database-Aware Storage Automation
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
12
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
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
HOT
Active
Frequent
Access
Occasional
Access
Dormant
Actively updated
Infrequently updated,
Frequently Queried
Infrequent access
for query and
updates
Long term analytics
& compliance
COLD
Only Oracle Automates Tiered Compression
Automatic Data Migration with ZS3 and Hybrid Columnar Compression
Active
This Quarter
UNCOMPRESSED
or ACO Row Store
for fast performance
Analytics
Compliance and Reporting
Uncompressed
Data
Uncompressed
Data
10x
15x
HCC
Data
HCC
Data
This Year
Prior Years
HCC Query for
Fast Analytics
HCC Archive for
Maximum Compression
Only with Oracle Storage
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
ORACLE DATABASE
12C AUTOMATIC
DATA OPTIMIZATION
converts less frequently
changed data to
HCC formats
The Top Five…Smarter Approaches to Alleviate Stress
1
Partitioning – Granular Control of Your Database
2
HCC – Massive Space Savings Plus Speed Gains
3
ADO with Heat Maps – Dynamic ILM and Compression
4
Direct NFS – Network Speed and Simplicity
5
OISP – Database-Aware Storage Automation
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
15
Direct NFS Architecture
Direct NFS client
NAS Storage
Database
…
…
LGWR I/O queue
DBWR I/O queue
DBWR TCP connection
…
PQ slave I/O queue
…
RMAN I/O queue
Parallel network
paths for scalability
and failover
LGWR 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
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Why Direct NFS for Primary Storage?
High Performance with Simplified Management and Reduced Costs
Relative Order Entry Performance
120.0%
102.3%
100.0%
100.6%
99.1%
• 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
80.0%
60.0%
40.0%
• High Performance
20.0%
0.0%
50
200
400
Number of Users
TPS 10GbE dNFS
– Direct NFS is optimally designed and tuned for
Database workloads
– Superior performance to kernel NFS or iSCSI
– Performance comparable to Fibre Channel
TPS FC
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
The Top Five…Smarter Approaches to Alleviate Stress
1
Partitioning – Granular Control of Your Database
2
HCC – Massive Space Savings Plus Speed Gains
3
ADO with Heat Maps – Dynamic ILM and Compression
4
Direct NFS – Network Speed and Simplicity
5
OISP – Database-Aware Storage Automation
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
18
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
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
“OISP is like a Bat Phone to the
Mayor’s office while everyone else
is on rotary dial.”
– Dave Vellante, Analyst, Wikibon
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
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
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
22