Setting Metric Thresholds for Selected Baselines

This section explains how to select a baseline and edit its thresholds. You can configure the type of threshold, for example, whether it is based on significance levels, percentage of maximum values, or fixed values. You can also configure the threshold levels that determine when the database generates critical alerts and warnings.

You can edit thresholds for the default moving baseline or a baseline that you created in the AWR Baselines page. You can select a baseline in the Edit Thresholds page after you have scheduled statistics computation from the AWR Baselines page and the statistics have finished computing on the static baseline.

To set a metric threshold for a selected moving baseline: 

1. On the Database Home page, under Related Links, click Baseline Metric Thresholds.

   The Threshold Configuration tab of the Baseline Metric Thresholds page appears.

2. In the View list, select Basic Metrics.

   The Baseline Metric Thresholds page appears.

3. In the Category/Name column, click the link for the metric whose threshold you want to set or change.

   For example, click Number of Transactions (per second).

   The Edit Thresholds: Number of Transactions (per second) appears.

   The charts on this page provide simple and detailed views of metric activity for a 24-hour period. In the top simple chart, click a day to view the value of the metric plotted against a 24-hour period.

4. Under AWR Baseline, in the Name list, select either the default SYSTEM_MOVING_WINDOW or the name of a baseline created in the AWR Baselines page.

   A baseline appears in the AWR Baseline list after you have scheduled statistics computation from the AWR Baselines page and the statistics have finished computing on the static baseline.

   The page refreshes to show the charts for the baseline that you selected.

5. In the Threshold Settings section, complete the following steps to change the settings:

   1. In Threshold Type, leave Significance Level selected.

   2. In Critical, select Extreme.

   3. In Warning, select Very High.

   4. In Occurrences, leave the current value.

6. Click Apply Thresholds.

   You are returned to the Baseline Metric Thresholds page. This page shows the altered metric threshold settings.