Examine the query and its output: What might have caused three of the alerts to disappear?

The correct answer is A. The threshold alerts were cleared and transferred to d0A_alert_history. DBA_OUTSTANDING_ALERTS: The DBA_OUTSTANDING_ALERTS means describes the outstanding alerts in the database and contains current database alerts. DBA_ALERT_HISTORY: The DBA_ALERT_HISTORY means lists a history of alerts that have been cleared and provides a history of nonthreshold…

Managing Performance

Question

Examine the query and its output:

What might have caused three of the alerts to disappear?

Exhibit

Options

AThe threshold alerts were cleared and transferred to d0A_alert_history.
BAn Automatic Workload Repository (AWR) snapshot was taken before the execution of the
CAn Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of
DThe database instance was restarted before the execution of the second query.

How the community answered

(22 responses)

A
64% (14)
B
18% (4)
C
5% (1)
D
14% (3)

Explanation

DBA_OUTSTANDING_ALERTS: The DBA_OUTSTANDING_ALERTS means describes the outstanding alerts in the database and contains current database alerts. DBA_ALERT_HISTORY: The DBA_ALERT_HISTORY means lists a history of alerts that have been cleared and provides a history of nonthreshold alerts.

Topics

#ADDM alerts#AWR#Database diagnostics#Performance monitoring

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice