Oracle Database Errors Tracker

Purpose

Monitors current errors on all stored objects (views, procedures, functions, packages, and package bodies) and notify when errors are found.

Monitored object types

Following object types can be monitored: <lu> <li>VIEW</li> <li>PROCEDURE</li> <li>FUNCTION</li> <li>PACKAGE</li> <li>PACKAGE BODY</li> <li>TRIGGER</li> <li>TYPE</li> <li>TYPE BODY</li> <li>LIBRARY</li> <li>JAVA SOURCE</li> <li>JAVA CLASS</li> <li>DIMENSION</li> </lu>

Configuration hints

Create a new rule and select a type of object to monitor. You can then filter on the object owner, name, and error text.<br/> Select if you want to monitor Warnings, Errors or both.

Set the maximum number of errors for a given object in the threshold field.

Surveillance table

Parameter	Description
Active	To enable/disable a rule
Object owner	A filter on the object owner
Object type	Select the type of object to monitor.
Object name	A filter on the object name
Error text	A filter on the error text
Error level	A filter on the error level
Number of errors
Auto clear	If checked, the alarm will be cleared as soon as the alarm condition is not met anymore
Alarm tag	This field allows to add custom text within the alarm message. %MSG% variable will containthe actual generated message and can be used such as: “my_prefix %MSG% my_suffix”. By default, tagwill be used as prefix.
Alarm	To enable alarm sending
Metric	To enable metric sending
Report	If checked, this line of surveillance will used for showing threshold and severity in the daily report

Generated metrics

metricId	metricUnit	metricTarget	metricDescription
ORACLE_DATABASE_DBERRTRK_DB_ERR_COUNTER	Integer	Number or errors