Identify the benefits of the multitenant container database

Overview

References

• Database Concepts
  • 17 Introduction to the Multitenant Architecture
    • Benefits of the Multitenant Architecture

Reading Notes

These notes all come from "Benefits of the Multitenant Architecture".

Benefits of the Multitenant Architecture for Database Consolidation

Database consolidation is the process of consolidating data from multiple databases into one database on one computer. Starting in Oracle Database 12c, the Oracle Multitenant option enables you to consolidate data and code without altering existing schemas or applications.

The benefits are:

• Cost reduction
• Easier and more rapid movement of data and code
• Easier management and monitoring of the physical database
• Separation of data and code
• Secure separation of administrative duties
• Ease of performance tuning
• Support for Oracle Database Resource Manager
• Fewer database patches and upgrades

Benefits of the Multitenant Architecture for Manageability

The multitenant architecture has benefits beyond database consolidation. These benefits derive from storing the data and data dictionary metadata specific to a PDB in the PDB itself rather than storing all dictionary metadata in one place. By storing its own dictionary metadata, a PDB becomes easier to manage as a distinct unit, even when only one PDB resides in a CDB.

The benefits are:

• Easier migration of data and code
• Easier testing of applications