Oracle Database 12c: Installation and Administration — Question 238

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic
Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

Answer options

• A. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
• B. It always compares the latest snapshot with the baseline snapshot for analysis.
• C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
• D. It requires at least four AWR snapshots for analysis.
• E. It calls other advisors if required, but does not provide recommendations about the advisors to be used.

Correct answer: A, C

Explanation

The correct answer A is true because ADDM evaluates performance by examining wait and CPU times of active sessions. Option C is correct since ADDM requires a minimum of two snapshots to conduct its analysis after each snapshot is created. Options B, D, and E are incorrect as they misrepresent how ADDM functions and its requirements for analysis.