1. Get Started with Performance Tuning
  2. Reactive Database Tuning
  3. Resolving Performance Degradation Over Time
  4. Managing Baselines
  5. Setting Metric Thresholds for Baselines
  6. Setting Metric Thresholds for Selected Baselines

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. Access the Baseline Metric Thresholds page, as explained in "Setting Metric Thresholds for the Default Moving Baseline".

  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.

    Description of edit_thresholds.gif follows
    Description of the illustration edit_thresholds.gif

    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.

    In this example, BASELINE_TUE_1120 is selected.

    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 the Threshold Type list, select a type.

    2. In the Critical list, select a level.

    3. In the Warning list, select a value.

    4. In the Occurrences list, select a value.

  6. Click Apply Thresholds.

    The Baseline Metric Thresholds page reappears. The page shows the altered metric threshold settings.