My Oracle Support Banner

Understanding Database Metrics in Dbconsole (Doc ID 1567473.1)

Last updated on MARCH 12, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Purpose

This article is about understanding the different types of metrics in dbconsole, and setting the desired metric thresholds, so that an alert is shown on the dbconsole homepage when the specified thresholds are hit. It is further possible to setup dbconsole for notification (by email, OS scripts, SNMP traps) etc. although that is out of the scope of this note.

Use this note to set up metrics so that warnings/critical alerts are shown on the dbconsole home page.

To set up dbconsole for email notification see:-

<Note:1566959.1> How to set up email notification in Database Control (Dbconsole)
<Note:1266924.1> How to set up dbconsole to send email notifications for a metric alert (eg. tablespace full)
<Note:1566987.1> How to set up SNMP Trap Notification in DBconsole

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 A) How are Database metrics set in dbconsole? 
 B) How to set the Collection Schedule for the metrics?
 11g Console
 10g Console
 C) What are suitable values for warning and critical thresholds?
 D) About the two types of metrics in Enterprise Manager dbconsole
 E) Metrics which are evaluated by the database server (Server Generated Alerts)
 F) Metrics which are evaluated by the Agent
 G) Testing a simple a Server Generated Alert
 H) Testing a simple agent evaluated alert.
 I) Troubleshooting Metric Alerts
 Troubleshooting Server Generated Alerts
 Troubleshooting Agent Evaluated Alerts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.