Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > DPA 12.1 Administrator Guide > Monitor database instances > About monitoring Oracle multitenant databases (CDBs)

About monitoring Oracle multitenant databases (CDBs)

Created by Melanie Boyd, last modified by Melanie Boyd on Nov 07, 2017

Views: 207 Votes: 0 Revisions: 2

Updated: November 62017

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

Last modified