8.2. Managing Server-Generated Alerts

Now that you've seen the role of the AWR, we can move ahead to the other elements in the CMI. The first will be server-generated alerts.

The term server-generated alerts refers to the database's ability to detect problematic situations and to send an alert with both notification of the problem and suggestions about how to resolve it. These alerts can be classified as either threshold or non-threshold alerts.

Threshold alerts leverage the metrics computed by the MMON process to determine potential performance problems. This is accomplished by comparing the current metrics to preset threshold levels. If the threshold is exceeded, an alarm is generated.

Non-threshold alerts are triggered by database events, ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.