4 - ADO 12c.pdf - Rocky Mountain Oracle Users Group

35 Pages·2013·1.97 MB·English

by  Tim Gorman

Automating Information
Lifecycle Management with
Oracle Database 12c
Rocky Mountain Oracle Users Group
http://www.RMOUG.org
Friday, 09-August 2013
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 © 2013, Oracle and/or its affiliates. All rights reserved.
Agenda
 Data Growth
 Heat Map
 Automatic Data Optimization
 Benefits of Heat Map and ADO
3 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Growth in Data Diversity and Usage
1,800 Exabytes of Data in 2011, 20x Growth by 2020
Today’s Drivers
Emerging Growth Factors

Mobile
Enterprise
#1 Internet access device in 2013
45% per year growth
in database data

Cloud
Big Data
80% of new
Large customers top 50PB
applications
and their data

Social Business
Regulation
$30B/year in commerce by 2015
300 exabytes in
archives by 2015
4 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Managing Storage Challenges
Manage more data Compress data, Tier and
without incurring without impacting compress data
additional cost performance based on usage
5 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Information Lifecycle Management
Managing Data Over its Lifetime
6 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Data Compression
Reduce storage footprint, read compressed data faster
Hot Data Warm Data Archive Data
111010101010101 101010101110101 101010101110101
10101010111010100110101 10101010111010100110101110000101000101 10101010111010100110101110000101000101101110101
001101010101011 001101011100001 001101011100001
11000010100010110111010 10111010101001010010010000100010101011 01001010010010000100010101011010010110100111000
010001011011000 010001011011101 010001011011101
10100101001001000010001 01001011010011100001010010010100001001 01010010010100001001000010001010101110011011100
110100101000001 010100101001001 010100101001001
01010110100101101001110 00001000101010111001101110011000111010
001110001010101 000010001010101 000010001010101
00010100100101000010010
101001011010010 101001011010011 101001011010011
00010001010101110011010
110001010010011 100001010010010 100001010010010

111001001000010 100001001000010 100001001000010
001010101101000 001010101101001 001010101101001

3X 10X 15X
Advanced Row Compression Columnar Query Compression Columnar Archive Compression
88 CCooppyyrriigghhtt ©© 22001132,, OOrraaccllee aanndd//oorr iittss aaffffiilliiaatteess.. AAllll rriigghhttss rreesseerrvveedd.. Confidential – Oracle Restricted
Oracle Advanced Compression
Transparent, Smaller, Faster
 100% Application Transparent
 End-to-end Cost/Performance Benefits across CPU, DRAM, Flash,
Disk & Network
 Runs Faster: OLTP Apps (Transactional & Analytics) & DW
 Reduces Database Footprint
– CapEx & OpEx savings
– Increases Cloud ROI through Database Footprint reduction in
DRAM Memory
9 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Understanding Data Usage Patterns
Database ‘heat map’
0 1 0 10 1 1 0 1 0 1 0 01 1 1 0 1 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11
0 0 01 1 0 1 0 1 10 1 0 1 0 1 0 1 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
00 11 1100 11 00 11 00 11 00 11 00 11 00 11 0011 00 00 11 1100 11 00 11 00 11 00 11 00 11 00 11 0011 00 00 11 1100 11 00 11 00 11 00 11 00 11 00 11 0011 00
11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11
0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11 1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11
00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 0 1 10 1 1 1 0 1 0 1 0 1 1 1 01 1 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
00 11 1100 11 11 11 00 11 00 00 00 11 11 11 0011 00 00 11 1100 11 11 11 00 11 00 00 00 11 11 11 0011 00 00 11 1100 11 11 11 00 11 00 00 00 11 11 11 0011 00
11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11
0101 00 11 11 00 11 1100 11 00 00 00 11 00 11 00 11 0101 00 11 11 00 11 1100 11 00 00 00 11 00 11 00 11 0101 00 11 11 00 11 1100 11 00 00 00 11 00 11 00 11
00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
00 11 0000 11 11 11 00 00 00 00 00 11 11 11 0011 11 00 11 0000 11 11 11 00 00 00 00 00 11 11 11 0011 11 1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1
11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11
1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11 0 1 10 1 1 1 0 1 0 1 0 1 1 1 01 1
00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 11 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 11 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1 00 11 1100 11 11 11 00 11 00 11 00 11 11 11 0011 11 00 11 1100 11 11 11 00 11 00 11 00 11 11 11 0011 11
11 0011 00 11 11 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 11 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 11 00 00 11 00 11 00 11 0011 11 00 11
11 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Understanding Data Usage Patterns
Database ‘heat map’
0 1 0 10 1 1 0 1 0 1 0 01 1 1 0 1 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11
0 0 01 1 0 1 0 1 10 1 0 1 0 1 0 1 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
00 11 1100 11 00 11 00 11 00 11 00 11 00 11 0011 00 00 11 1100 11 00 11 00 11 00 11 00 11 00 11 0011 00 00 11 1100 11 00 11 00 11 00 11 00 11 00 11 0011 00
11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11
0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11 1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11
00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 0 1 10 1 1 1 0 1 0 1 0 1 1 1 01 1 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
00 11 1100 11 11 11 00 11 00 00 00 11 11 11 0011 00 00 11 1100 11 11 11 00 11 00 00 00 11 11 11 0011 00 00 11 1100 11 11 11 00 11 00 00 00 11 11 11 0011 00
11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11
0101 00 11 11 00 11 1100 11 00 00 00 11 00 11 00 11 0101 00 11 11 00 11 1100 11 00 00 00 11 00 11 00 11 0101 00 11 11 00 11 1100 11 00 00 00 11 00 11 00 11
00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
00 11 0000 11 11 11 00 00 00 00 00 11 11 11 0011 11 00 11 0000 11 11 11 00 00 00 00 00 11 11 11 0011 11 1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1
11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 00 00 00 11 00 11 00 11 0011 11 00 11
1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1 0101 00 00 11 00 11 1100 11 00 11 00 11 00 11 00 11 0 1 10 1 1 1 0 1 0 1 0 1 1 1 01 1
00 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 11 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11 11 11 00 11 0011 11 00 11 00 11 00 11 0011 11 00 11
1 01 0 1 0 0 0 1 0 1 0 1 01 1 0 1 00 11 1100 11 11 11 00 11 00 11 00 11 11 11 0011 11 00 11 1100 11 11 11 00 11 00 11 00 11 11 11 0011 11
11 0011 00 11 11 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 11 00 00 11 00 11 00 11 0011 11 00 11 11 0011 00 11 11 00 00 11 00 11 00 11 0011 11 00 11
12 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.