Using Out-of-the-Box Metric Widgets

You can add out-of-the-box metric widgets to a dashboard and visualize and display the metrics stored in Enterprise Manager.

The out-of-the-box metric widgets access and obtain the metric data uploaded to the Enterprise Manager Management Repository and display it in a visual format. The visualization of metric data in a widget makes it easy to monitor and interpret. Depending on the duration for which you want to display metric data in the widgets, it is fetched from the following sources:

  • Metric data for a duration of less than 2 days is fetched from RAW data.
  • Metric data for a duration of 2 to 14 days is fetched from the hourly roll-up table.
  • Metric data for a duration of more than 14 days is fetched from the daily roll-up table.

Here is a scenario that illustrates how to create a new dashboard and use the Target Metric - Line metric widget to display the Active Sessions: CPU metric for a specific Pluggable Database (PDB):

  1. Navigate to the Dashboards page.
  2. Click Create Dashboard to create a new dashboard.

    A blank untitled dashboard is displayed.

  3. In the About tab, specify a name for the dashboard, and optionally add a description for the dashboard.
  4. In the Widgets tab, type Target Metric - Line in the search field to view the widget in the list of out-of-the-box widgets.
  5. Click or drag and drop the Target Metric - Line widget to add it to the new dashboard.

    As you add the widget to the dashboard, you must configure the inputs to display the Active Sessions : CPU metric for a specific PDB. Here is more information on the options you can select:

    1. In the Configure Target Type input for Target Metric - Line (Required) dialog, select the Specify the Target Type input option and select the Pluggable Database option in the drop-down list.
    2. In the Configure Target Name input for Target Metric - Line (Required) dialog, select the Specify the Target Name input option and select the specific PDB in the drop-down list.
    3. In the Configure Metric Name input for Target Metric - Line (Required) dialog, select the Specify the Metric Name input option and select Wait Count in the drop-down list.
    4. In the Configure Metric Column input for Target Metric - Line (Required) dialog, select the Specify the Metric Column input option and select Active Sessions : CPU in the drop-down list.

    On configuring these inputs, the Target Metric - Line widget is added to the dashboard and displays the number of active sessions using CPU for the specified PDB in a line chart. The Edit Widgets tab on the right displays the details of the widget, and this includes the list of inputs configured for the widget. To make changes to the input configuration, click the Edit icon (Edit) adjacent to the input. For example, in the Target Metric - Line widget, the time input is linked to the dashboard time by default, however, you can edit this input and specify a different duration of time.

  6. Click Save changes to save the dashboard.
Similar to the Target Metric - Line widget that displays metric data for a single target, you can also use the Group - Metrics - Line widget that displays historical metric data for a target type. For the Group - Metrics - Line widget, in addition to the required inputs that must be configured when adding the widget, you can configure the following optional inputs to further customize the metric data:
  • Aggregate Target Type: The Group option is selected by default, however, you can change the aggregate target type. Any target type that has been defined to have members, is listed as an aggregate target type.
  • Number of Targets: The default number of top targets for which data is displayed is 5, however, you can change this to display data for more or fewer targets. The top <n> targets are determined based on the highest average metric value queried from the hourly roll-up table.
  • Rollup Column: The pre-aggregated column that must be selected from the historical metric table. Historical metric data is pre-aggregated using standard functions such as average, min, and max. Average is the default function, however, you can edit the Rollup Column input and select the Min or Max functions.
  • Key Aggregate Function: The function used to aggregate multiple key metric values for a target for a given time stamp. Average is the default function, however, you can edit the Key Aggregate Function input and select the Min, Max, or Sum functions.

    Here is a scenario that illustrates how Key Aggregate Function can be used. A Windows host target has multiple drives (keys), such as C: and D:, and the file system in the C: drive uses 1.5 GB and the file system in the D: drive uses 2 GB. You can select the FileSystem Used metric, which is a key metric for host targets and select Sum as the Key Aggregate Function to view the total file system usage in the Windows host at a given time: 1.5 + 2 = 3.5 GB.

  • Time: The time input is set to the last 7 days by default, however, you can specify a different duration of time for which metric data will be displayed.