?

Which two are true about server-generated alerts? (Choose two.)

• A.?Stateful alerts must be created by a DBA after resolving the problem.
• B.?Stateless alerts can be purged manually from the alert history.
• C.?Stateless alerts can be cleared manually.
• D.?Stateless alerts are automatically cleared.
• E.?Stateful alerts are purged automatically from the alert history.

?

Correct Ans: BC
There are two kinds of server-generated alerts: threshold and nonthreshold.
Most server-generated alerts are configured by setting a warning and critical threshold values on
database metrics. You can define thresholds for more than 120 metrics, including the following:
? Physical Reads Per Sec
? User Commits Per Sec
? SQL Service Response Time
Except for the Tablespace Space Usage metric, which is database related, the other metrics are
instance related. Threshold alerts are also referred to as stateful alerts, which are automatically
cleared when an alert condition clears. Stateful alerts appear in DBA_OUTSTANDING_ALERTS and,
when cleared, go to DBA_ALERT_HISTORY.
Other server-generated alerts correspond to specific database events, such as ORA-* errors,
“Snapshot too old” errors, Recovery Area Low On Free Space, and Resumable Session Suspended.
These are non-threshold-based alerts, also referred to as stateless alerts. Stateless alerts go directly to the History table

?

?

?

?

?

?

?