Oracle Database Administration II — Question 174

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

Answer options

• A. When ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time.
• B. It runs automatically after each AWR snapshot.
• C. By default it analyzes a period of time corresponding to the last 4 hours of activity.
• D. Results are written to the alert log.
• E. By default it analyzes a period of time corresponding to the last 24 hours of activity.

Correct answer: A, B

Explanation

Option A is correct because ADDM can report cumulative impacts of findings that exceed 100% of DB time, which reflects the overlapping nature of issues. Option B is also correct as ADDM is designed to run automatically after each AWR snapshot to provide timely analysis. Options C, D, and E are incorrect; C and E provide incorrect default time periods for analysis, while D is incorrect because results are typically not written directly to the alert log.