Which two are sources for detailed alert information?

You define the Warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the Critical threshold to be 80%. When space usage of the USERS tablespace exceeds 60%, an alert is raised.
Which two are sources for detailed alert information? (Choose two.)

You define the Warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the Critical threshold to be 80%. When space usage of the USERS tablespace exceeds 60%, an alert is raised.
Which two are sources for detailed alert information? (Choose two.)

A.
the alert.log file

B.
the V$ALERT_TYPES view

C.
the DBA_ALERT_HISTORY view

D.
the Database Control Home page

E.
the DBA_ALERT_ARGUMENTS view

F.
the DBA_OUTSTANDING_ALERTS view

G.
the Database Control Performance page

H.
the Database Control Administration page

Explanation:
The database issues a warning alert when reclaimable space is less than 15% and a critical alert when reclaimable space is less than 3%. To warn the DBA of this condition, an entry is added to the alert log and to the DBA_ OUTSTANDING _ALE R TS table (used by Enterprise Manager). However, the database continues to consume space in the Flash Recovery Area until there is no reclaimable space left. REF.: Metalink Note: 305812.1- Flash Recovery area – Space management Warning & Alerts



Leave a Reply 0

Your email address will not be published. Required fields are marked *