Oracle Database 12c: Advanced Administration — Question 125

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: B

Explanation

The AWR Compare Period report is specifically designed to analyze performance over different time periods, allowing you to pinpoint changes effectively. In contrast, the Compare Period ADDM report focuses more on recommendations rather than direct performance comparisons, while the ASH report provides real-time session data without historical context. Taking a new snapshot and comparing it lacks the structured analysis that the AWR report offers.