Upgrade to Oracle Database 12c — Question 24

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 specifically designed to analyze performance changes by comparing two distinct time periods in an Oracle database. While the AWR Compare Period report provides historical performance data, it does not focus on pinpointing specific changes as effectively as the ADDM report. The ASH report gives insights into active sessions but does not directly compare performance across periods, and taking a new snapshot lacks the detailed analysis provided by the ADDM tool.