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:
Navigate to Environment > All Objects > Oracle Database.
Double-click on the desired object (resource).
Select the Details tab, then Views.
The available views for that resource are listed and can be selected.