The publishing of Oracle 12c Release 1 (12.1) has been hailed as a game changer in the database management industry. It has been cited by DBA gurus as the most radical architectural change in the history of Oracle databases.
If you have been searching for the best remote DBA services, it behooves on you to get some insight on the ingenious multitenant option to leverage on its amazing features. Here are some of the important aspects on the Oracle pluggable database to help you appreciate its uniqueness.
Overview of the Pluggable Database Architecture
The new Oracle multitenant architecture allows a multitenant container database to hold many pluggable databases in the root container. The thinking behind the new construct is to allow a DBA to easily adopt an existing database without any accompanying application changes.
The pluggable database construct allows you to encapsulate a sub-set of Oracle indexes and data table files with metadata from the data dictionary. Once you create a root instance database or the container database (CDB) you can then go ahead and add other pluggable databases or tenants (PDB) within an architectural separation.
The beauty of this new approach in database design is the fact that more than one database can exist within an instance. In the traditional database, only one database could exist per instance.
Outstanding Benefits of Oracle Pluggable Databases
Oracle database innovations set trends in the industry, and for many good reasons. With the Oracle 12c Release 1 (12.1) your business will enjoy some of these benefits:
- Rapid provisioning and cloning: Creating pluggable databases, moving them around between containers and cloning of these databases takes seconds through new SQL commands. It is possible to clone terabytes instantaneously through a single command and this makes the work of a DBA easier while enhancing efficiency.
- Easy database consolidation: Compared to the old architecture, pluggable databases allow easier consolidation because they share the single multitenant container’s memory and background processes. In essence, you will get all the benefits of a schema-based consolidation, but without the attendant application changes.
- Easier management of the databases: Database administration processes are easier because the pluggable databases are managed as one. Processes such as data recovery and backups are easily done from the multitenant container database level.
- Improved resource management: With the new pluggable database, you will enjoy better resource utilization. This is because competition for resources by the pluggable databases is controlled by the Resource Manager, which is specifically tweaked for this function.
- Easier maintenance: You will not have to worry about myriad upgrades for all individual pluggable databases. Instead, you will be able to upgrade all databases by upgrading the container database. Patching and tuning your database for optimum performance will not be a complicated affair.
Creating pluggable databases is an easy task since the bulk of the working parts are already in the root container. What’s more, your DBA is able to unplug a PDB from the root container and then plug it into another CDB. Well, this is what gives the multitenant option its admirable flexibility.
BIO
Joab Harrison is an enterprise and software consultant working from Florida. He has extensive experience in Oracle enterprise products and his consultancy firm is renowned for the best remote DBA services.