Oracle Database 12c: Advanced Administration — Question 172

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

Answer options

• A. Database Replay
• B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
• C. Active Session History (ASH) report
• D. SQL Performance Analyzer

Correct answer: B

Explanation

The Automatic Database Diagnostic Monitor (ADDM) Compare Period report is specifically designed to analyze performance changes over time and can highlight what factors contributed to the degradation. The other options, while useful, do not provide the comparative analysis necessary to pinpoint the exact cause of the performance drop.