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
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