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


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.


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


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.


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


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

Oracle Multitenant customer successes

Enterprise customers from around the world are consolidating their Oracle Database environments using Oracle Multitenant to achieve greater operating efficiencies and lower costs.

  • APRO Software Solutions logo
  • Comcast logo
  • IQMS logo
  • Sportmaster logo
  • Swiss Mobiliar logo

Oracle Multitenant use cases

Related products

Oracle Real Application Clusters

High availability and scalability for Oracle Databases

Active Data Guard

Disaster recovery and data protection for enterprise data

Oracle GoldenGate

High availability and zero downtime migrations for databases

Oracle Database In-Memory

Accelerate analytic and transactional workloads

Get started with Multitenant

Try it out

Experiment and learn Multitenant in the Oracle Cloud for free.

Contact us

Find out how Oracle Multitenant can help you.