1.1.8 Operation with a multitenant container database (CDB) configuration

If the monitoring-target program is Oracle Database 12c Release 2 or later, PFM - RM for Oracle can operate with a multitenant container database (referred to hereafter as the CDB) configuration, in addition to a traditional non-multitenant container database (referred to hereafter as the non-CDB) configuration.

In a CDB configuration environment, instances of PFM - RM for Oracle are created for each pluggable database (referred to hereafter as the PDB) and monitored. PFM - RM for Oracle can also monitor the root container (CDB$ROOT). Monitoring application containers (an application root and application PDBs) is not supported.

In a CDB configuration, the records that are supported on monitoring PDBs and the root container are different from the supported records in a non-CDB configuration. Also, some of the records or fields collect the following performance data:

Information for the PDBs to be monitored and the range of the root container to be monitored
Common information for database instances

For details, see 5. List of records for PFM - RM for Oracle or the descriptions of each record field.

Organization of this subsection

(1) Operating a CDB configuration in single-instance
(2) Operating a CDB configuration in an Oracle RAC
(3) Note

(1) Operating a CDB configuration in single-instance

The following show operations used when monitoring with a non-CDB configuration and with a CDB configuration.

(a) When monitoring a non-multitenant container database (non-CDB)

Instance of PFM - RM for Oracle for each Oracle instance are created and monitored.

Figure 1‒3: Monitoring with a non-CDB configuration

(b) When monitoring the root container (CDB$ROOT) or PDBs

Instance of PFM - RM for Oracle are created, and a PDB and the root container are monitored.

Figure 1‒4: Monitoring with a CDB configuration (with a single PDB)

Instance of PFM - RM for Oracle are created, and PDBs and the root container are monitored.

Figure 1‒5: Monitoring with a CDB configuration (with multiple PDBs)

To Page Top

(2) Operating a CDB configuration in an Oracle RAC

When operating in an Oracle RAC configuration, it appears that one Oracle instance is running from the application, but each node is running an Oracle instance under the node's own instance name. For example, a tablespace is shared by each node, but I/O information is unique to each node. Therefore, when operating a CDB configuration in Oracle RAC, create instances of PFM - RM for Oracle and monitor it so that it monitors the PDB and the root container (CDB$ROOT) on each node.

The following shows the configurations of PFM - RM for Oracle and the Oracle database when operating a non-CDB configuration and when operating a CDB configuration in Oracle RAC.

(a) When monitoring a non-multitenant container database (non-CDB)

Instance of PFM - RM for Oracle for each Oracle instance of each node are created and monitored.

Figure 1‒6: Operating a non-CDB configuration in an Oracle RAC

(b) When monitoring the root container (CDB$ROOT) or PDBs

Instance of PFM - RM for Oracle are created, and the PDB and the root container of each node are monitored.

Figure 1‒7: Operating a CDB configuration (singletenant) in an Oracle RAC

Instance of PFM - RM for Oracle are created, and the PDB and the root container of each node are monitored.

Figure 1‒8: Operating a CDB configuration (multitenant) in an Oracle RAC

To Page Top

(3) Note

When monitoring multiple PDBs or root containers (CDB$ROOT) in a CDB configuration (multi-tenant), create an instance of PFM - RM for Oracle that monitors each container. The number of instances that can be created depends on the system configuration, resource status, number of records to be monitored, and collection interval. Please verify the situation thoroughly before operating.

To Page Top