Oracle Database 12c: Installation and Administration — Question 57

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

Answer options

• A. Compare Period ADDM report
• B. AWR Compare Period report
• C. Active Session History (ASH) report
• D. Taking a new snapshot and comparing it with a preserved snapshot

Correct answer: A

Explanation

The Compare Period ADDM report is designed to analyze performance changes over different time periods, making it the most suitable tool for identifying the cause of performance differences. While the AWR Compare Period report also compares performance metrics, it lacks the detailed analysis provided by the ADDM. The ASH report focuses on active sessions rather than overall database performance changes, and taking a new snapshot compares current performance to a past state without the analytical depth of ADDM.