Oracle Multitenant

Oracle Multitenant enables an Oracle Database to function as a container database (CDB). A CDB consolidates multiple pluggable databases (PDB), a portable collection of schemas, schema objects, and non-schema objects. Whether deployed on-premises or in the cloud, with Oracle Multitenant, applications run unchanged in self-contained PDBs, improving resource utilization, management, and overall security.

Oracle Database 19c: Multitenant Cloud Database Architecture (7:40)

Oracle Multitenant features

Rapid cloning and provisioning

Local clones and remote clones

Database administrators save time by provisioning pluggable databases as clones locally or from across the network without disrupting the source.

Snapshot clones

Create storage efficient pluggable databases in seconds that mirror full data set copies of the source pluggable database for development and testing environments.

Refreshable PDBs

Maintain up to date copies of production databases by periodically topping them up with incremental transactions.

Manage many as one

Database consolidation

Achieve large scale consolidation with support for up to 4,096 (4k) pluggable databases per container database in Oracle Exadata, Oracle Cloud, and 252 pluggable databases per container database on other platforms, lowering costs for IT departments.

Improve productivity

Increase database administrator productivity by performing patching, backups, configuration, and upgrades centrally.

Maintain granular control

IT teams retain granular control when necessary, such as performing point-in-time recovery (PITR) at the individual pluggable database level.

Improve agility for development teams

Patching

Oracle Multitenant customers can patch an individual pluggable database or patch all pluggable databases as needed.

Pre-configured service level agreement

Pre-configure one or more container databases for each service level agreement.

Compatibility

Applications run unchanged in a pluggable database, making adoption of Oracle Multitenant extremely simple.

Interface

Easy to use SQL interface for developers and database administrators.

Enhance security

Separation of duties

Oracle Database Vault prevents privileged user access inside a pluggable database, between the pluggable database and the common privileged user at the container database.

Data security

Protect data at rest with transparent data encryption (TDE) where each pluggable database has its own encryption key.

Resource isolation

Resource manager ensures that each pluggable database eliminates “noisy neighbors” and defends customers against denial-of-service (DOS) attacks.

Integration with Oracle Real Application Clusters (Oracle RAC)

High availability

Integration with Oracle RAC enables automatic re-distribution of pluggable database workloads during planned and unplanned downtime, ensuring high availability for customers.

Scalability

Scale single container database across a multi-node cluster with no application changes to support sudden changes in customer workloads.

Flexibility

Move a pluggable database between servers with no downtime, application changes or any changes to connect strings for end users.

Integration with Oracle Real Application Clusters (6:07)