october 1st - pic.huodongjia.comnov 20, 2017 · database consolidation - prior to oracle 12c. 7...
TRANSCRIPT
![Page 1: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/1.jpg)
Database Consolidation using Oracle MultitenantPini Dibask, Product Manager for Database SolutionsOctober 1st, 2017
![Page 2: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/2.jpg)
Confidential2
• Pini Dibask, Product Manager, Database Monitoring Solutions (Quest)
• Based in Israel
• Oracle DBA since 2006 (started with version 9i)
• Oracle Certified Professional DBA (OCP)
• Public Speaker: Oracle OpenWorld, IOUG Collaborate, DOAG, OUGN, AOUG
• Blogger: OracleDBPro.BlogSpot.com
http://Linkedin.com/in/pinidibask
@pini_dibask
About Me
OracleDBPro.BlogSpot.com
![Page 3: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/3.jpg)
Confidential3
• Quest is now an independent company again!
• Simplifies IT management
• #1 independent software company for Database Tools
• Driven by innovation
“Spend less time on what you need to do, and more time on what you want to do!”
• Committed to providing great products and superior support
About
![Page 4: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/4.jpg)
Confidential4
• Introduction to Database Consolidation
• Oracle Multitenant Concepts
• Ensuring QoS in Multitenant Environments
• RAC and Multitenant
• Performance Monitoring for Multitenant Environments
Agenda
![Page 5: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/5.jpg)
Introduction to Database Consolidation
![Page 6: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/6.jpg)
Confidential6
Server Consolidation
Multiple databases reside on a single server
Database Consolidation - Prior to Oracle 12c
![Page 7: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/7.jpg)
Confidential7
Database Consolidation
Single database with multiple schemas
Database Consolidation - Prior to Oracle 12c (Cont’d)
![Page 8: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/8.jpg)
Confidential8
Name Collisions
Same schema name or same public synonym name
Security
DBA can access data of both applications
Upgrades
You cannot patch/upgrade only one schema
Point-In-Time Recovery
Impossible to perform schema level point-in-time recovery
Database Consolidation with Schema Separation - Challenges
![Page 9: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/9.jpg)
Multitenant Architecture
![Page 10: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/10.jpg)
Confidential10
Pluggable Database
Self-contained Oracle database
Root Container
Oracle-supplied metadata
Database to Instance Relationship
supplied metadata
![Page 11: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/11.jpg)
Confidential11
One SGA
One set of background processes
One root container
Multiple pluggable databases
Up to 252 PDBs (12cR1)
Up to 4096 PDBs (12cR2)
Oracle 12c – Multitenant Architecture
Only on Oracle Cloud and
Oracle Exadata
![Page 12: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/12.jpg)
Confidential12
Pluggable Databases share the following files:
Undo Tablespace
Redo Logs
Control Files
(S)Pfile
Oracle 12c – Multitenant Architecture (Cont’d)
Local undo introduced in
12cR2
![Page 13: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/13.jpg)
Confidential13
Multitenant Architecture - Containers
s
CON_ID Description
0 Entire CDB/Non-CDB
1 Root container
2 Seed container
3-4098 User PDBs
Created by default -Used as a template PDBfor cloning
![Page 14: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/14.jpg)
Confidential14
Data Guard
Data Guard operates at CDB-Level
Maintenance at CDB-Level = Reduced DBA efforts
Manage Many as One
![Page 15: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/15.jpg)
Confidential15
RMAN - Granular Backup & Restore Options
Backup entire CDB at once or at PDB level
Recover entire container at once or at PDB level
Multitenant Advantages - Manage Many as One
s
s
![Page 16: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/16.jpg)
Confidential16
Moving PDB from one container to another is straightforward
Multitenant Advantages - Unplug/Plug
s
![Page 17: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/17.jpg)
Confidential17
Clone PDB from another PDB within the same CDB
Requires source PDB to be OPEN READ ONLY (12cR1)
Multitenant Advantages - Fast Cloning
s
Hot Clones are available
in 12cR2
![Page 18: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/18.jpg)
Confidential18
Clone PDB from another PDB in remote CDB
Requires source PDB to be OPEN READ ONLY (12cR1)
Multitenant Advantages - Fast Cloning
Hot Clone is available in
12cR2s
![Page 19: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/19.jpg)
Confidential19
Refreshable PDB – Allows refreshing contents of a cloned PDB
Step 1 – takes a full clone. Doesn’t require any downtime due to hot clone feature
Step 2 - refresh by applying redo logs (either on-demand or automatically scheduled)
Refreshable PDB should be in a read-only mode
Multitenant Advantages - Easy Replication (12c Release 2)
s
![Page 20: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/20.jpg)
Confidential20
Upgrades
Upgrade or apply a patch at CDB-Levelhttps://blogs.oracle.com/UPGRADE/entry/upgrade_pdbs_everything_at_once1
Unplug/plug PDB into another container databasehttps://blogs.oracle.com/UPGRADE/entry/upgrade_pdbs_one_at_a
Multitenant Advantages - Manage Many as One
![Page 21: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/21.jpg)
Confidential21
CDB Level vs. PDB-Level
CDBCDB-CDB-Level• Oracle Software
• SGA & Background Processes
• RMAN Scheduled Backups
• Data Guard
• Some Parameters(IsPDB_Modifiable= 'FALSE')
• Control Files, Redo
• (S)Pfile, Password File
PDBPDB-PDB-Level• FLUSH SHARED_POOL
• FLUSH BUFFER_CACHE
• Point In-Time Recovery
• RMAN Ad hoc Backups
• Some Parameters(IsPDB_Modifiable= 'TRUE')
• Undo Tablespace (12cR2)
• Character Set (12cR2)
• Flashback Database (12cR2)
![Page 22: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/22.jpg)
Confidential22
Non-CDB
• Same as before 12c
Oracle 12c – Deployment Options
DB CDB$ROOT CDB$ROOT
PDB1 PDB1 PDB2 PDB252
Single Tenant
• No additional license
• Available in SE/SE1/SE2
• One active PDB
Multitenant
• Option on top of Enterprise Edition
• Supports up to 4096 active PDBs
…
![Page 23: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/23.jpg)
Confidential23
Why use Single Tenant instead of Non-CDB?
Unplug/Plug
Fast Cloning
but most importantly …
(source: Oracle 12c Release 2 Documentation)
Oracle 12c – Deployment Options (Cont’d)
![Page 24: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/24.jpg)
Confidential24
Oracle 12c – DBCA
Non-CDB Single Tenant / Multitenant
![Page 25: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/25.jpg)
Ensuring High Level of QoSwith Multitenant Environments
![Page 26: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/26.jpg)
Confidential26
PDB-Level QoS challenge
Allocation of resources among competing sessions
Example: One session consumes too many resources
CDB-Level QoS challenge
Allocation of resources among competing PDBs
Example: One PDB consumes too many resources
QoS Challenges – Multitenant Environments
![Page 27: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/27.jpg)
Confidential27
Resource Manager Elements
Resource Plan
Resource Plan Directive
Consumer Group
Oracle Resource Manager - The Basics (Pre 12c)
Resource Plan“WEEKEND”
Directive 170% of CPU
Directive 220% of CPU
Directive 310% of CPU
Consumer Group“WAREHOUSE”
Consumer Group“OLTP”
Consumer Group“OTHERS_GROUPS”
![Page 28: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/28.jpg)
Confidential28
PDB-Level Resource Plan
Specifies how resources are allocated to consumer groups
Prioritize resources between competing sessions
CDB-Level Resource Plan
Specifies how resources are allocated to PDBs
Prioritize resources between competing PDBs
The Solution - Oracle Resource Manager
![Page 29: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/29.jpg)
Confidential29
Oracle Resource Manager - 12c Multitenant
CDB Resource Plan Directive CPU Shares
CPU Utilization Limit
Parallel Servers Limit
Example:
Pluggable Pluggable Database
CPU CPU Shares
Guaranteed Guaranteed CPU
CPU Limit Parallel Servers Parallel Servers Limit
OLTP 3 3/4 = 75% 100% 100%
DWH 1 1/4 = 25% 60% 100%
![Page 30: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/30.jpg)
Confidential30
Oracle Resource Manager - 12c Multitenant
Obtain information about default CDB resource plan
Obtain information about default PDB directive
s
s
![Page 31: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/31.jpg)
Confidential31
Example of CDB-Level Resource PlanResource Plan
“Daytime_CDB_PLAN”
PDB“OLTP”
PDB“DWH”
Directive 2Guaranteed CPU: 25%Maximum CPU: 60%
Directive 1Guaranteed CPU: 75%Maximum CPU: 100%
Pluggable Pluggable Database
CPU CPU Shares
Guaranteed Guaranteed CPU
CPU Limit Parallel Servers Parallel Servers Limit
OLTP 3 3/4 = 75% 100% 100%
DWH 1 1/4 = 25% 60% 100%
![Page 32: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/32.jpg)
Confidential32
s
Creating CDB Resource Plan
Pluggable Pluggable Database
CPU CPU Shares
Guaranteed Guaranteed CPU
CPU CPU Limit
OLTP 3 3/4 = 75% 100%
DWH 1 1/4 = 25% 60%
![Page 33: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/33.jpg)
Confidential33
s
Creating CDB Resource Plan (Cont’d)
![Page 34: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/34.jpg)
Confidential34
Enabling/Disabling CDB Resource Plan
Manually enabling resource plan
Manually disabling resource plan
s
s
![Page 35: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/35.jpg)
Confidential35
Enabling/Disabling CDB Resource Plan (Cont’d)
s
Automatically Enable/Disable CDB Resource Plan
![Page 36: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/36.jpg)
Confidential36
PDB Level Memory Resource Management
Not available in 12c Release 1
12c Release 2 - Memory parameters can be set at PDB level SGA_TARGET DB_CACHE_SIZE DB_SHARED_POOL_SIZE PGA_AGGREGATE_LIMIT PGA_AGGREGATE_TARGET SGA_MIN_SIZE
New in 12cRelease 2
![Page 37: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/37.jpg)
Confidential37
PDB Level I/O Resource Management
Not available in 12c Release 1
12c Release 2 Introduced the following new parameters: MAX_IOPS - limits number of I/O operations per second MAX_MBPS - limits megabytes for I/O operations per second Default : 0 (no limit)
If Oracle waits due to I/O limit “resmgr: I/O rate limit” wait event will appear
Cannot be set in a Non CDB
![Page 38: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/38.jpg)
Confidential38
How Many Resources Actually Being Used by PDBs?
Option #1 - DBA_HIST_RSRC_PDB_METRIC
Displays historical resource manager metrics by PDB
Option #2 - AWR_ROOT_RSRC_PDB_METRIC (underlying AWR table)
Option #3 - AWR Reports
![Page 39: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/39.jpg)
Confidential39
Maintenance Tasks in Oracle Multitenant
ENABLE_AUTOMATIC_MAINTENANCE_PDB parameter
Can be used to enable/disable running of maintenance tasks
Default: true
Can be set at either CDB or PDB levels
AUTOTASK_MAX_ACTIVE_PDBS parameter
Maximum number of PDBs that can schedule maintenance tasks concurrently
Default: 2 (two PDBs and the CDB root can run tasks at the same time)
Can be set at CDB level only
Both parameters introduced in 12c Release 2
![Page 40: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/40.jpg)
RAC & Multitenant
![Page 41: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/41.jpg)
Confidential41
Single Instance & Multitenant challenges
Not Scalable = Limited Consolidation Solution
Instance Down Downtime for all PDBs
RAC makes Multitenant better
Scalable = True consolidation solution
Available = Instance Down PDBs continue running on other nodes
Why RAC & Multitenant?
![Page 42: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/42.jpg)
Confidential42
Multitenant fully supports RAC
PDBs can be opened on specific instances
RAC & Multitenant
s
![Page 43: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/43.jpg)
Confidential43
PDBs workload distributed across RAC instances
RAC & Multitenant
Services
Single SGA perCDB Instance
Node1
CDB Instance 1
Node1 Node2
CDB Instance 2
Multitenant Container Database (CDB)
![Page 44: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/44.jpg)
Confidential44
PDBs workload distributed across RAC instances
RAC & Multitenant
Services
Single SGA perCDB Instance
Node1Node1
CDB Instance 1
Node2
CDB Instance 2
Node3
CDB Instance 3
Node3
Multitenant Container Database (CDB)
![Page 45: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/45.jpg)
Confidential45
RAC & Multitenant
s
Preferred Instance Available Instance
![Page 46: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/46.jpg)
Confidential46
RAC & Multitenant
s PDB opened only in Preferred instance
PDB automatically starts in the other instance
Shutting down the preferred instance
![Page 47: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/47.jpg)
Performance Monitoring for Multitenant Environments
![Page 48: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/48.jpg)
Confidential48
Snapshots taken only at CDB-Level
AWR data reside in cdb$root container
Multitenant & AWR – Oracle 12c Release 1
![Page 49: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/49.jpg)
Confidential49
Multitenant & AWR – Oracle 12c Release 1 (Cont’d)
s
![Page 50: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/50.jpg)
Confidential50
AWR reports are available only at CDB level
AWR Management Operations only at CDB level
AWR data retention
Snapshot schedule
Taking manual snapshots
Purging snapshot data
Unplugged PDB does not contain AWR information
Multitenant & AWR – Oracle 12c Release 1 (Cont’d)
![Page 51: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/51.jpg)
Confidential51
Multitenant & AWR – Oracle 12c Release 1 (Cont’d)
![Page 52: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/52.jpg)
Confidential52
Snapshots can be taken either at CDB or PDB level
Snapshot data reside in SYSAUX tablespace of each PDB
It is possible to create a report at PDB-level AWR report
AWR management operations at either CDB or PDB level
New Parameter : AWR_PDB_AUTOFLUSH_ENABLED
Specifies whether to enable automatic AWR snapshots for PDBs
Default : false (automatic AWR snapshots are disabled for PDBs)
Can be set at CDB or PDB level
Multitenant & AWR – Oracle 12c Release 2
![Page 53: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/53.jpg)
Confidential53
Multitenant & AWR – Oracle 12c Release 2 (Cont’d)
![Page 54: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/54.jpg)
Confidential54
Workload Analysis using OEM ASH Analytics
Only with Enterprise Edition +
Diagnostics Pack
![Page 55: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/55.jpg)
Confidential55
Workload Analysis using Foglight for Oracle
![Page 56: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/56.jpg)
Confidential56
Workload Analysis using Foglight for Oracle
![Page 57: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/57.jpg)
Confidential57
Workload Analysis using Foglight for Oracle
![Page 58: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/58.jpg)
Confidential58
Introduction to the Multitenant: Architecture (Documentation)http://docs.oracle.com/database/122/CNCPT/introduction-to-the-multitenant-architecture.htm#CNCPT89234
Oracle Multitenant (White Paper)http://www.oracle.com/technetwork/database/multitenant-wp-12c-1949736.pdf
Oracle Multitenant: New Features in Oracle Database 12c Release 12 (White Paper)http://www.oracle.com/technetwork/database/multitenant/overview/multitenant-wp-12c-2078248.pdf
Mike Dietrich Blog
https://blogs.oracle.com/UPGRADE/
Note: All diagrams and illustrations are used by permission of Oracle
References
![Page 59: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/59.jpg)
Q&A
![Page 60: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/60.jpg)
• Are you being asked to evaluate or move mission-critical business operations to Cloud-based solutions?
• Join #IOUGCloudJourney to understand what the Cloud means for your organization and your career.
• Throughout the next year we will provide videos, webinars, user stories and other resources to help make this transition a smooth one for you and your organization.
• Learn how to adapt your processes to optimize Cloud usage and plan for future engagements or expansion.
• Use our 12-18 month skill set roadmap to prepare for your job today, and your career tomorrow.
Visit www.ioug.org/journey-to-the-cloud to get started - no login required
![Page 61: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/61.jpg)
Save the DateCOLLABORATE 18 registration will open on Wednesday, November 8.
Call for SpeakersSubmit your session presentation! The Call for Speakers is open until Friday,
October 20
collaborate.ioug.org
Save the Date
![Page 62: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/62.jpg)
Got Lunch Plans Today?Learn about User Groups in your area, hear Lightning Talks
and get some Pizza from 11:30-3:30
Registration Required:
http://ora.cl/pO1yL(that’s a little p, big O, one, little y, big L)
![Page 63: October 1st - pic.huodongjia.comNov 20, 2017 · Database Consolidation - Prior to Oracle 12c. 7 Confidential Database Consolidation Single database with multiple schemas Database](https://reader034.vdocuments.us/reader034/viewer/2022052102/603ce063448a417e85639d02/html5/thumbnails/63.jpg)
Thank You!