Skip to content

Category: Database Basics

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

Published March 20, 2020 By Brijesh Gogia

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.

Continue ReadingOracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB

Leave a Comment

Oracle Multitenant DB 2 : Benefits of the Multitenant Architecture

Published March 19, 2020 By Brijesh Gogia

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:

Continue ReadingOracle Multitenant DB 2 : Benefits of the Multitenant Architecture
Leave a Comment

Oracle Multitenant DB 1 : Basics of Oracle Multitenant architecture

Published March 18, 2020 By Brijesh Gogia

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.

Continue ReadingOracle Multitenant DB 1 : Basics of Oracle Multitenant architecture

Leave a Comment