Skip to content

Expert Oracle Posts

Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB

From the user and application perspective, the data dictionary in each container in a CDB is separate, as it would be in a non-CDB.

For example, the DBA_OBJECTS view in each PDB can show a different number of rows. This dictionary separation enables Oracle Database to manage the PDBs separately from each other and from the root.

Leave a Comment

Oracle Multitenant DB 2 : Benefits of the Multitenant Architecture

Oracle Multitenant database can provide few good benefits if we plan carefully and specially by having a non-traditional approach. In the starting it may seem intimidating to the seasoned DBAs as this architecture need some learning and practice.  Few of the key benefits which Oracle describes are mentioned below:

Leave a Comment

Oracle Multitenant DB 1 : Basics of Oracle Multitenant architecture

The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB).

This feature is available in Oracle Database 12c or later releases so you must install or upgrade to Oracle Database 12c or later releases. The database compatibility level must be set to 12.0.0 or later to utilize the multitenant feature.

Leave a Comment