You define the Warning threshold for the tablespace usage metric for the USERS tablespace to be 35%. Because of this, several alerts are being raised. After observing this, you decide to increase the Warning threshold and clear all old alerts related to tablespace usage metric.
Where would you fund the information about cleared alerts?
A.
The alert.log file
B.
The DBA_ALERT_HISTORY data dictionary table
C.
The DBA_ALERT_ARGUMENTS data dictionary table
D.
The DBA_TAB_STATS_HISTORY data dictionary table
E.
The DBA_OUTSTANDING_ALERTS data dictionary table
F.
The V$ACTIVE_SESSION_HISTORY data dictionary table
Explanation:
The following dictionary views provide information about server alerts:
* DBA_THRESHOLDS lists the threshold settings defined for the instance.
* DBA_OUTSTANDING_ALERTS describes the outstanding alerts in the database. *DBA_ALERT_HISTORY lists a history of alerts that have been cleared. (B)
* V$ALERT_TYPES provides information such as group and type for each alert.
* V$METRICNAME contains the names, identifiers, and other information about the system metrics.
* V$METRIC and V$METRIC_HISTORY views contain system-level metric values in memory.
REF.: Oracle 10g Administrator Guide, 4-21
REF.: Oracle 10g Administrator Guide, 4-21