Database Reference
In-Depth Information
Advantages and Benefits of the Multitenant Architecture
The purpose of the multitenant architecture is to consolidate databases to conserve or
fully utilize physical server resources. The multitenant architect is designed to help the
DBA eliminate unnecessary overhead and fully utilize hardware by consolidating multiple
databases from multiple computers into a single container database on a single computer.
Benefits of the multitenant architecture include the following:
Overall reduction in hardware requirements, since you can run more databases on the
same server.
More efficient management and movement of data and code.
Simpler management of the database.
Differentiation in duties between PDB administrators and CDB administrators: PDB
administrators can focus on the specific application and users they manage; CDB
administrators can focus on the system, performance, backups, and overall security.
Benefits of PDBs include these:
Provisioning of a new PDB is simple.
Moving an existing PDB to another platform is easily accomplished by unplugging and
plugging in.
It's easier to patch or upgrade all the PDBs in a CDB as one instead of separately.
The DBA can also unplug a PDB and plug it into a newer version CDB.
A server can run one CDB with multiple PDBs more efficiently than running multiple
non-CDBs.
From a licensing perspective, Oracle Multitenant is an option that you pur-
chase in addition to the base license. At the time of this writing the base
Oracle license will allow you to create a container database with one plug-
gable database in it, referred to as single-tenant. If you configure more than
one pluggable database in your container database, then you will need to
purchase the Oracle Multitenant option. For current licensing information,
check the Oracle Database 12 c Licensing document included in the Oracle
Database 12 c Documentation Library, found at http://docs.oracle.com .
In an environment with multiple databases and various platforms, the multitenant envi-
ronment offers a destination in which the DBA can consolidate and manage systems that
were previously required to exist independently. Using pluggable database technology, the
DBA can consolidate databases onto servers that offer greater CPU and memory density,
higher throughput, lower operational cost, lower overall energy consumption, fewer storage
and network connections, and higher degrees of transportability.
Database consolidation reduces DBA workload and cost through easier overall man-
agement. Managing 1 SGA on 1 server, even if it has 100 PDBs, is simpler than managing
Search WWH ::




Custom Search