About monitoring Oracle multitenent databases (CDBs)

If you are using DPA to monitor Oracle CDBs, see the following information about registration, grouping, and annotations.

Registration and automatic grouping

To monitor an Oracle multitenant container database (CDB), register the pluggable databases (PDBs) contained in the CDB. Register each PDB just as you would register an Oracle single tenant database. For more information, see Registration and licensing options for clustered environments.

When you register two or more Oracle PDBs in the same CDB, DPA automatically creates a group for the CDB. This group is used for all registered PDBs from the CDB. If a DBA moves a PDB to a new CDB, DPA processes and groups the instance.

View the PDB load

On the DPA homepage, click the CDB to view summary data across the PDB instances. Use this view to determine which PDB has the most wait time, and what types of waits the PDBs are experiencing.

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.

  1. Click Options.
  2. Under Administration > Configuration, click Advanced Options.
  3. Click the ORACLE_CDB_AUTO_GROUP system option.
  4. 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.