About monitoring Oracle multitenant databases
If you are using DPA to monitor the databases within an Oracle multitenant database (CDB), see the following information about registration, grouping, and annotations.
Registration and automatic grouping
Register each of the pluggable databases (PDBs) contained in a CDB, and, in DPA 2024.4 and later, you can also register the CDB. (Registering the CDB is optional.) Register each PDB or CDB just as you would register an Oracle single tenant database. For more information, see Registration and licensing options for clustered environments.
DPA automatically creates a group that includes all registered PDBs in the same CDB, as well as the CDB (if registered). If a DBA moves a PDB to a new CDB, DPA regroups the instance.
View the PDB load
On the DPA home page, you can:
-
Click the CDB name to view summary data from all PDB instances in the group. Use this view to determine which PDB has the most wait time and what types of waits the PDBs are experiencing.
-
Expand the CDB group and click a PDB name to view activity and investigate performance issues on that database instance.
Automatic annotations
Annotations are automatically added to wait time charts when a PDB is added, removed, or moved from one CDB to another. The annotations allow you to compare performance before and after the change.
Turn off automatic grouping of Oracle CDBs
If you do not want DPA to automatically group the PDBs within a CDB, you can turn automatic grouping off.
- Click Options.
- Under Administration > Configuration, click Advanced Options.
- Click the ORACLE_CDB_AUTO_GROUP system option.
- Select False from the New Value list, and click Update.
After you set this option to false, grouping of registered database instances does not change. Only newly registered or updated database instances are affected, and are not grouped.