CDB and PDB Architecture in Oracle Database 19c

The CDB (Container Database) and PDB (Pluggable Database) architecture in Oracle Database 19c is a multi-tenant architecture that provides improved resource management, security, and performance. Here is a detailed overview of the architecture:

CDB: A CDB is a database that contains one or more PDBs, as well as a set of common components that are shared across all PDBs. The common components include the root container, which is the CDB itself, and the seed PDB, which is used as a template for creating new PDBs.

PDBs: PDBs are isolated databases that run within a CDB, and can be used to host individual applications or workloads. Each PDB has its own set of users, objects, and data, and can be managed and maintained independently from the other PDBs within the CDB.

System Global Area (SGA): The SGA is a shared memory area that is used by all PDBs within the CDB. This allows the PDBs to share resources and improve performance, as the SGA can be dynamically resized based on the needs of the PDBs.

Background processes: The CDB and PDB architecture in Oracle Database 19c uses common background processes to manage the CDB and PDBs, improving resource management and reducing overhead.

Security: The CDB and PDB architecture provides improved security, as each PDB has its own set of users and roles, and access to PDBs can be controlled and audited.

Data and application isolation: Each PDB is isolated from the other PDBs within the CDB, providing a high level of data and application isolation. This reduces the risk of cross-application interference and improves security.

Backups and recovery: The CDB and PDB architecture provides improved backup and recovery capabilities, allowing you to back up and recover individual PDBs without affecting the entire CDB.

Performance: The CDB and PDB architecture can improve performance, as the shared components can be used by multiple PDBs, reducing the overhead associated with managing multiple databases.

These are the key components of the CDB and PDB architecture in Oracle Database 19c. Understanding this architecture is essential for effective administration and management of Oracle databases in a multi-tenant environment.