Server-Generated Alerts

In an effort to provide capabilities that are typically obtained using third-party software, Oracle 10g now provides server-generated alerts directly from the Oracle Database server. These notifications act as an early warning of a potential or impending problem. They often contain suggestions for correcting the problem. Notifications are also provided when the problem condition has been addressed.

Alerts are generated when a problem occurs or when data does not match expected values for user-configurable metrics, such as

Physical reads per second

File system out of space

User commits per second

SQL response time

Maximum extents reached

Server-generated alerts can be based on threshold levels or can be issued simply because an event has occurred. Threshold-based alerts can be configured to send notifications at both warning and critical threshold levels. Other alerts are based on conditions such as ORA- errors in the alert log. Some examples of this type of alert are