Documentation forDatabase Performance Analyzer

About monitoring Oracle multitenent databases

If you are using DPA to monitor the databases within an Oracle multitenent database (CDB), see the following information about registration, grouping, and annotations.

Registration and automatic grouping

Register each of 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.

You cannot register the CDB for monitoring. DPA monitors only the PDBs.

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 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.

  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.