Oracle Database 12c: Installation and Administration — Question 93

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

Answer options

• A. The ADDM requires at least four AWR snapshots for analysis
• B. The ADDM runs after each AWR snapshot is collected automatically by MMON
• C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
• D. The ADDM analysis provides only diagnostics information but does not provide recommendations
• E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

Correct answer: B, C

Explanation

Option B is correct because the ADDM indeed runs automatically following the collection of each AWR snapshot by MMON. Option C is also correct as the results from the ADDM analysis are stored in the Automatic Workload Repository. Options A, D, and E are incorrect because ADDM does not require four snapshots, it provides recommendations, and it does suggest actions based on findings.