View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.
After 30 minutes, you executed the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;
REASON METRIC_VALUE
———————————————————– ——————————
Tablespace [TEST] is [28 perce 28.125 nt] full 28.125
What could be the reason for the elimination of the other rows in the output?
A.
The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
B.
The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
C.
An Automatic Workload Repository snapshot has been taken recently.
D.
The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.