Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

The correct answer is B. It runs automatically after each AWR snapshot. C. A DBA can run it manually.. An ADDM analysis task is performed and its findings and recommendations stored in the database every time an AWR snapshot is taken provided the STATISTICS_LEVEL parameter is set to TYPICAL or ALL. The time period analyzed by ADDM is defined by the last two snapshots (the last hou

Monitoring and Tuning

Question

Options

AIt analyzes a period of time corresponding to the 12 hours of activity.
BIt runs automatically after each AWR snapshot.
CA DBA can run it manually.
DResults are written to the alert log.
EIt analyzes a period of time corresponding to the last day of activity.

How the community answered

(58 responses)

A
5% (3)
B
81% (47)
D
12% (7)
E
2% (1)

Explanation

An ADDM analysis task is performed and its findings and recommendations stored in the database every time an AWR snapshot is taken provided the STATISTICS_LEVEL parameter is set to TYPICAL or ALL. The time period analyzed by ADDM is defined by the last two snapshots (the last hour by default).

Topics

#ADDM#AWR snapshots#performance diagnostics#automatic monitoring

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice