Oracle Database 12c: Installation and Administration — Question 247

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report? (Choose three.)

Answer options

• A. It detects any configuration change that caused a performance difference in both time periods.
• B. It identifies any workload change that caused a performance difference in both time periods.
• C. It detects the top wait events causing performance degradation.
• D. It shows the resource usage for CPU, memory, and I/O in both time periods.
• E. It shows the difference in the size of memory pools in both time periods.
• F. It gives information about statistics collection in both time periods.

Correct answer: A, B, D

Explanation

The correct answers A, B, and D are relevant because they focus on identifying specific changes that impact performance, such as configuration and workload adjustments, as well as resource usage. Options C, E, and F, while informative, do not directly address the primary concerns of performance change detection as highlighted in the context of the ADDM report.