Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > DPA 11.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: 86 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 > Administration > Advanced Options.
  2. Click the ORACLE_CDB_AUTO_GROUP system option.
  3. 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

Tags

Classifications

Public