Setting Metric Thresholds

Oracle Database provides a set of predefined metrics, some of which have predefined thresholds. There may be times when you want to set thresholds for other metrics, or you want to alter existing threshold settings.

"Changing Space Usage Alert Thresholds for a Tablespace" describes one means of setting a threshold, where you set warning and critical thresholds on the amount of space consumed in a tablespace. A more general means of setting thresholds is available using the Edit Thresholds page.

To set metric thresholds:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. Under the Related Links heading, click Metric and Policy Settings.

   The Metric and Policy Settings page appears.

   This page displays the existing thresholds for metrics and any response actions that have been specified.

3. In the View list, do one of the following:

   • Select Metrics with thresholds to view only those metrics with thresholds, either predefined by Oracle or previously set by you.

   • Select All Metrics to view all metrics, whether they have thresholds defined.

4. To set or modify a warning threshold for a particular metric, enter the value you want in the Warning Threshold field for that metric.

5. To set or modify a critical threshold for a particular metric, enter the value you want in the Critical Threshold field for that metric.

6. To disable or reenable metric collection for a particular metric, or to change its collection schedule, complete the following steps:

   1. Click the Collection Schedule link for the metric.

      The Edit Collection Settings page for that metric appears.

   2. Click Disable to disable collection for this metric, or click Enable to enable it.

   3. If you chose Enable, then you must choose the Frequency Type for the Collection Schedule and enter a numeric value in the Repeat Every field.

      If you chose Disable, then skip this step.

   4. Do one of the following:

      • Click Continue to save your choices and return to the Metric and Policy Settings page.

      • Click Cancel to return to the Metric and Policy Settings page without saving your choices.

7. Click a single-pencil icon to use the Edit Advanced Settings page to make changes to Corrective Actions, (Monitoring) Template Override, and Advanced Threshold Settings. Click Help on this page for more information about these options.

8. Click a triple-pencil icon to set different threshold values for different instances of the object type being measured.

   For example, for each tablespace you can set different warning and critical levels for the Tablespace Space Used metric.

9. Do one of the following:

   • Click OK to save your changes and return to the Database Home page.

   • Click Cancel to return to the Database Home page without saving your changes.