Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

The correct answer is B. It determines the segments on which waits are occurring when the database has a high number of C. It analyzes the performance of the database instance based on the latest two AWR snapshots. Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/diagnsis.htm#g41683

New Features for Performance

Question

Options

AIt analyzes only those memory components of the database instance that are impacting performance.
BIt determines the segments on which waits are occurring when the database has a high number of
CIt analyzes the performance of the database instance based on the latest two AWR snapshots.
EIt recommends implementing SQL profiles to generate better execution plans.
FIt analyzes only the components and waits that are impacting database performance.

How the community answered

(21 responses)

A
5% (1)
B
76% (16)
E
14% (3)
F
5% (1)

Explanation

Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/diagnsis.htm#g41683

Topics

#ADDM#AWR snapshots#performance diagnostics#wait analysis

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice