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 refer