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.