Saturday, November 9, 2013

Oracle Database 12c – Container Database & Pluggable Databases

Oracle 12c Pluggable databases allow DBAs to consolidate large number of Oracle database applications into a single, larger RDBMS installation.

Before Oracle 12c, if you have large number of Oracle Database Applications we have to include the following factors.
  • Too many background processes (Based on Oracle Database Instances)
  • High shared / Process memory (Memory Allocations for the SGAs
  • Many copies of Oracle Metadata (Storage space for Data Dictionaries for multiple databases)
  • Upgrading multiple oracle database instances time-consuming process for DBAs
  • Multiple backup sets and schedules for multiple databases.  

Oracle 12c has brought the following advantages for multiple Oracle database instances in one Oracle Database Server.
  • Oracle 12c operates multiple oracle database instances in a centrally managed platform
  • DBAs time saving for patching and upgrade
  • No application changes required for Oracle database consolidation
  • Fast and easy to provision multiple databases in Centralized platform
  • Provides Isolation
  • Fully operates with Oracle Real Application Clusters (RAC)
  • A machine can run more number of oracle database instances in the form of Pluggable Databases (PDBs) than as individual Oracle database instance.
A Container database in Oracle database 12c is a set of database schemas that appears logically to users and applications as separate Oracle database
In Oracle database 12c, an instance is associated with an entire CDB (Container database).

Consider the following:
Container Database    : cdb1
Pluggable databases   : pdb1 & pdb2

Query to check whether the Database is Multitenant Database CDB:

Information on Pluggable Databases (PDBs) in Container Database (CDB):

 Query on currently connected instance:
 Query on SGA Usage by Pluggable Databases (PDBs):
Query on PGA Usage by Pluggable Databases (PDBs) :
Connection Information for Container Database and Pluggable Databases:
Connection Information for Container Database and Pluggable Databases:
 Information on Datafiles Of Container Database and Pluggable Databases:
Continued in Part-2

No comments:

Post a Comment