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 change the default thresholds to meet the needs of your environment. The custom thresholds can apply to a specific database instance or all monitored instances.

View the current thresholds

  1. On the DPA homepage, 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 Settings below the chart.

    The Resource Settings page displays the current thresholds.

Change the thresholds

  1. Select Custom.
  2. Enter the new Critical and Warning threshold values.
  3. Do one of the following:
    • To use the new values only for this database instance, click OK.

    • To use the new values for all database instances, click Save As Default. Then click Yes and OK at the confirmation prompts.

      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 selected (instead of Use Defaults) will continue to use those custom thresholds.