The Management Pack for Oracle Database creates views that allow the user to view statistics of metrics for Oracle Database resources. The views help give a broad picture of the entire system, as opposed to a more in depth view.

The following views are available in the Management Pack:

View Type Description
Oracle Database Configuration List Shows Oracle Database Properties
Oracle Database Overview List Shows key metrics for Oracle Databases
Oracle Health List Shows health and availability for all Oracle objects
Oracle Instance Overview List Oracle Instance Overview
Oracle Instance Waits List Shows wait values for Oracle Instances
Oracle Slow Queries List Shows top slowest queries by Oracle Instance
Oracle Tablespace List Shows Tablespace metrics
Oracle Instance Configuration List Shows properties for Oracle Instances

To access the Management Pack views:

  1. Navigate to Environment > All Objects > Oracle Database.
  2. Double-click on the desired object (resource).
  3. Select the Details tab, then Views.

The available views for that resource are listed and can be selected.

Accessing Views