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