Documentation forDatabase Performance Analyzer

View or change DPA resource metric thresholds

Resource metric charts in DPA indicate when the metric has exceeded a Warning or Critical threshold. You can create alerts based on resource metric thresholds.

You can change the default thresholds to meet the needs of your environment. If a metric does not have default thresholds, you can add them. The custom thresholds can apply to a specific database instance or all monitored instances.

View the current thresholds

  1. On the DPA home page, click the database instance whose resource metric thresholds you want to view.

    If you are going to change the default thresholds for all database instances, you can click any instance.

  2. Click the Resources tab.
  3. Click the tab that displays the metric whose thresholds you want to view or change.

  4. Locate the metric chart and click to the right of the chart.

    The Resource Settings page displays the thresholds that are currently used for this metric.

Change the thresholds

  1. Select Custom.

    If the metric has default thresholds, the Custom dialog box initially shows the default values.

    If the metric does not have default thresholds, the Custom dialog box shows the Warning and Critical thresholds as disabled.

  2. Enter the new threshold values:

    • If the metric does not have default thresholds, click the toggle switch next to each threshold level you want to enable.

    • If you enable both the Warning and Critical threshold levels, enter the same value at the intersection of the two levels:

      • For metrics that alert on higher values, enter the same number as the maximum Warning value and the minimum Critical value.

        DPA issues a Warning alert when the value is within the Warning range (inclusive). DPA issues a Critical alert when the value is greater than the minimum Critical threshold.

        Example: For the thresholds shown in step 1, DPA issues a Warning alert when the value is 10 through 20. DPA issues a Critical alert when the value is greater than 20.

      • For metrics that alert on lower values, enter the same number as the minimum Warning value and the maximum Critical value.

        DPA issues a Warning alert when the value is within the Warning range (inclusive). DPA issues a Critical alert when the value is less than the minimum Critical threshold.

        Example: For the thresholds shown below, DPA issues a Warning alert when the value is 90 through 95. DPA issues a Critical alert when the value is less than 90.

  3. Do one of the following:

    • To use the new values only for this database instance, click Save.

    • To use the new values for all database instances, click Save As Default.

      When you Save As Default, the new default threshold values are used for all database instances unless custom thresholds have been specified for an instance. Any database instance with custom thresholds will continue to use those thresholds.