Migra&ng to Database 12c Mul&tenant: New Opportuni&es To Get It Right!
A Lunch & Learn webinar for IT Management
Brought by Performance Tuning Corpora&on www.perIuning.com
Expert Panelist
Dan Morgan Oracle ACE Director Performance Tuning Corpora&on hLps://www.linkedin.com/pub/dan-‐morgan/0/aa9/a5
Introduc&on: Daniel Morgan • Oracle ACE Director • Wrote Oracle curriculum and primary program instructor at University of Washington • Oracle consultant to Harvard University • The Morgan behind Morgan's Library on the web
www.morganslibrary.org • 10g, 11g, and 12c Beta tester • Member: New York Oracle Users Group • Re&red chair Washington SoIware Assoc. Database SIG • Co-‐Founder Interna&onal GoldenGate Users Group • Never an employee of Oracle Corp.
• Founded in 1997 – Team spun out of Compaq Performance Lab – Focused on solving the tough/complex and messy data architecture problems – Very Senior team of EXPERTS
• Over 1000 clients & coun&ng • Key industries: Financial Services, Telecom, Oil & Gas,
Healthcare • Oracle Pla&num Partner: Two Oracle Ace Directors on staff
About PTC Select Clients
• Oracle Database • Oracle GoldenGate • System Deployment, Migra&on and Upgrades • Knowledge Transfer
Focus on: High Performance Architectures
Agenda • Background • Hope • Disappointment • Change • Wrap Up
Background
In The Beginning There Was Codd
Two Paths Lead to RDBMS
Project Ingres
Project Oracle
A Brief History of the Oracle Database
1978
1979
1982
1984
1986
1989
1993
1997
Oracle8i
Oracle8
Oracle7
Oracle 6
Oracle 5
Oracle 4
Oracle 3
Oracle 2
1999
Oracle 1
Oracle9i 2001
2004 Oracle 10g
Oracle 11g 2007
2013 Oracle 12c
1978
1979
1982
1984
1986
1989
1993
1997
Oracle8i
Oracle8
Oracle7
Oracle 6
Oracle 5
Oracle 4
Oracle 3
Oracle 2
1999
Oracle 1
Oracle9i 2001
2004 Oracle 10g
Oracle 11g 2007
2013 Oracle 12c
Triggers Rollback Segments
Redo Logs
A Brief History of the Oracle Database
1978
1979
1982
1984
1986
1989
1993
1997
Oracle8i
Oracle8
Oracle7
Oracle 6
Oracle 5
Oracle 4
Oracle 3
Oracle 2
1999
Oracle 1
Oracle9i 2001
2004 Oracle 10g
Oracle 11g 2007
2013 Oracle 12c
Triggers introduced
PL/SQL (packages/procedures/functions)
Rollback Segments
Redo Logs
A Brief History of the Oracle Database
1978
1979
1982
1984
1986
1989
1993
1997
Oracle8i
Oracle8
Oracle7
Oracle 6
Oracle 5
Oracle 4
Oracle 3
Oracle 2
1999
Oracle 1
Oracle9i 2001
2004 Oracle 10g
Oracle 11g 2007
2013 Oracle 12c
Triggers introduced
PL/SQL (packages/procedures/functions)
Rollback Segments
Redo Logs
Multi-tenant architecture
A Brief History of the Oracle Database
Jurassic Databases Management
DBA Self-Image
DBA Reality
The More Things Change
Reasons We Upgrade • Loss of vendor support • Loss of compa&bility • Leverage new feature • Regulatory and Governance requirements • Employee reten&on
Tradi&onal Upgrade Considera&ons • What is it going to cost? • How fast can we do it? • How much down &me will be required? • Are there compa&bility issues? • What is our fallback if the upgrade fails?
What We Miss When a new feature is included, at no cost, Oracle sales does not know it exists: Rarely are they discovered and implemented
Edition Based Redefinition
Predefined Inquiry Directives
Online Data Comparison
DBMS_COMPARISON
Table Compression
Save Exceptions Pragmas Bigfile Tablespaces
Virtual Columns Hidden Columns
Function-Based Indexes
Pipelined Table Functions
Block Change Tracking
Setting Optimizer Statistics
Copying Optimizer Statistics
Native Compilation
User Profiles
Password Verify Function Consumer Groups
Advanced Rewrite
Online Object Redefinition
Feature Usage Reports
Automated Partition Maintenance
Resumable Transactions
Sparse Collections Distributed Trust Administration If you buy food today and throw it away next week ... you wasted your money If you licensed valuable technology but didn't use it ...
Conditional Compilation If I taught a class tomorrow titled "Oracle New Features" and included nothing in the class that wasn't at least 10 years old almost no one in my seminar would know the difference.
What Never Materializes • Lower Total Cost of Ownership • Greater Stability • Improved Security • Improved Performance • Improved Systems Compa&bility
Why They Never Materializes • We focus is on implementa&on not planning • Our goal is a higher version number not on what, specifically, will be gained by the organiza&on
• LiLle aLen&on on knowledge transfer
Focus
What 12c Mul&tenant Can Offer • Lower Total Cost of Ownership
– You pay for Oracle licenses by cpu core – 50% u&liza&on = 50% of your investment wasted – Today, by default, essen&ally all of Oracle's customers are was&ng ~10% of their investment in storage array
Industrial Strength Money Wastage [Ticket] Commented: (1246816) mount points filled 100% on dc1laxdb01 and dc1laxdb03
Hi, Two mounts got filled 100%, please add space as early as possible. /u108 on dc1laxdb01 /export/home on dc1laxdb03 There are only datafiles in both mount points, Thanks Murphy
Industrial Strength Money Wastage
-bash-3.00$ df -h Filesystem size used avail capacity Mounted on /dev/md/dsk/d100 37G 11G 26G 29% / /devices 0K 0K 0K 0% /devices ctfs 0K 0K 0K 0% /system/contract proc 0K 0K 0K 0% /proc mnttab 0K 0K 0K 0% /etc/mnttab swap 61G 2.1M 61G 1% /etc/svc/volatile objfs 0K 0K 0K 0% /system/object sharefs 0K 0K 0K 0% /etc/dfs/sharetab fd 0K 0K 0K 0% /dev/fd /dev/md/dsk/d500 20G 4.6G 15G 24% /var swap 62G 1.4G 61G 3% /tmp swap 61G 142M 61G 1% /var/run /dev/dsk/c6t600601606AD11900E033B69AFA43DD11d0s2 115G 46G 68G 41% /u01 /dev/md/dsk/d132 31G 2.2G 29G 8% /var/crash /dev/md/dsk/d60 9.8G 6.4G 3.3G 66% /export/home /dev/md/dsk/d402 422M 5.1M 374M 2% /global/.devices/node@2 /dev/md/dsk/d404 481M 5.0M 428M 2% /global/.devices/node@4 /dev/md/dsk/d401 415M 74M 299M 20% /global/.devices/node@1 /dev/md/dsk/d403 481M 5.0M 428M 2% /global/.devices/node@3 /dev/md/sf14/dsk/d112 4.2T 4.1T 34G 100% /u112 /dev/md/sf14/dsk/d101 2.1T 2.0T 52G 98% /u101 /dev/md/sf14/dsk/d109 2.1T 1.8T 239G 89% /u109 /dev/md/sf14/dsk/d111 197G 3.5G 191G 2% /u111 /dev/md/sf14/dsk/d100 2.1T 2.0T 31G 99% /u100 /dev/md/sf14/dsk/d107 264G 73G 188G 28% /u107 /dev/md/sf14/dsk/d102 1.0T 1005G 58G 95% /u102 /dev/md/sf14/dsk/d106 264G 36G 225G 14% /u106 /dev/md/sf14/dsk/d113 4.0T 3.6T 326G 92% /u113 /dev/md/sf14/dsk/d110 3.0T 946G 2.0T 32% /u110_arch /dev/md/sf14/dsk/d104 2.0T 1.9T 37G 99% /u104 /dev/md/sf14/dsk/d105 2.0T 2.0T 537M 100% /u105 /dev/md/sf14/dsk/d108 2.0T 2.0T 2.0G 100% /u108 /dev/md/sf14/dsk/d103 2.0T 1.9T 47G 98% /u103
Industrial Strength Money Wastage Allocated Available
31 29
10 3
4200 34
2100 52
2100 239
197 191
2100 31
264 188
1000 58
264 225
4000 326
3000 2000
2000 37
2000 1
2000 2000
2000 47
27,266 5,461
The database is stopped because they are "out of space." Yet 20% of the space allocated has never been used.
Industrial Strength Money Wastage Summing the iden&fied space wastage More than 50% of the money spent on disk was wasted more than 25% totally unusable
Vacuum Wasted
Not allocated for data files 5.5T
Freespace in LOB Tablespace 6.2T
Space in used blocks 2.3T
Total 14T (more than 50% of the 27.3T allocated)
What 12c Mul&tenant Can Offer • Greater Stability
– The DBMS_RESOURCE_MANAGER package has been in the Oracle database since version 8.1.5
– Greatly enhanced func&onality in Database 12c – Resources can be priori&zed by
• Database • Applica&on • User
What 12c Mul&tenant Can Offer • Improved Security
– Unified Audit Policies – New Security Creden&als – Common Users and Common Roles – Secure Provisioning from Seed Databases – New Data Masking Technology
What 12c Mul&tenant Can Offer • Improved Performance
– Superior op&mizer algorithms – Superior SQL rewrite capabili&es – Improved resource management
What 12c Mul&tenant Can Offer • Improved CompaCbility
– SQL Transla&on Profiles
Planning To achieve benefits you must:
1. Transfer knowledge to your team
2. Iden&fy what has value
3. Deploy with a focus on quan&fiable business benefits
Some things cannot be done in a 2 week sprint
Summary • During the next 24 months most of you will upgrade to Database 12cR1
• If you do not leverage the advantages in the new architecture you may get liLle more for your effort other than a new version number
Any Ques&ons?
Thank you!
EXPERTS
Expert Data Services team with deep performance tuning and Oracle technology backgrounds.
More info: www.perftuning.com [email protected] 206-669-2949 Skype: damorgan11g @perftuning