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, ...