1.1.7 Operation with a multitenant container database (CDB) configuration
If the monitoring-target program is Oracle Database 12c Release 2 or later, PFM - Agent 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.
The following monitoring activities are possible in a CDB configuration environment:
-
When the root container (CDB$ROOT) or the pluggable databases (referred to hereafter as the PDBs) are to be monitored
Instances of PFM - Agent for Oracle can be created for each root container (CDB$ROOT) or PDB for monitoring.
Use this configuration for monitoring if you want to monitor the operating status of each root container (CDB$ROOT) or PDB or if you want to acquire detailed performance data.
Note that the monitoring of each application container (an application root and application PDBs) is not supported.
-
When all PDBs are to be monitored from the root container (CDB$ROOT) to which they belong
Instances of PFM - Agent for Oracle for monitoring the root container (CDB$ROOT) can be created to monitor the following performance data:
-
The open mode and size of all PDBs belonging to the root container (CDB$ROOT)
When the size of each PDB is to be monitored, if the maximum storage sizes (MAX_SIZE, MAX_DIAG_SIZE, and MAX_AUDIT_SIZE) of PDBs are either not set or set to unlimited in the Oracle Database to be monitored, values corresponding to each maximum storage size and the size of each available free space would be 0, and the percentage of each available free space would be 100. Under this circumstance, field monitoring is not possible. For details, see the information provided in 6. List of records for PFM - Agent for Oracle.
-
The size of the tablespaces of both the root container (CDB$ROOT) and all the open PDBs that belong to it
Use this configuration for monitoring if you want to monitor the root container (CDB$ROOT) so that you can centrally monitor the open mode or other performance data of all the PDBs that belong to it.
-
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. Furthermore, some records and fields collect data from only monitored PDBs and root container while others collect common information via a database instance.
For details, see 6. List of records for PFM - Agent for Oracle or the descriptions of each record field.
- Organization of this subsection
(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 - Agent for Oracle for each Oracle instance are created and monitored.
(b) When monitoring the root container (CDB$ROOT) or PDBs
Instance of PFM - Agent for Oracle are created, and a PDB and the root container are monitored.
Instance of PFM - Agent for Oracle are created, and PDBs and the root container are monitored.
(c) When monitoring the root container (CDB$ROOT) to monitor all PDBs belonging to it
Instances of PFM - Agent for Oracle are created for monitoring the root container (CDB$ROOT) so that all PDBs belonging to it can also be monitored.
(2) Operating a CDB configuration in an Oracle RAC
The following shows the configurations of PFM - Agent 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 - Agent for Oracle for each Oracle instance of each node are created and monitored.
(b) When monitoring the root container (CDB$ROOT) or PDBs
Instance of PFM - Agent for Oracle are created, and the PDB and the root container of each node are monitored.
Instance of PFM - Agent for Oracle are created, and the PDB and the root container of each node are monitored.
(c) When monitoring the root container (CDB$ROOT) to monitor all PDBs belonging to it
Instances of PFM - Agent for Oracle for monitoring the root container (CDB$ROOT) are created to monitor the root container (CDB$ROOT) of each node as well as the PDBs belonging to it.
(3) Note
When monitoring multiple PDBs or root containers (CDB$ROOT) in a CDB configuration (multi-tenant), create an instance of PFM - Agent 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.