Upgrade Oracle DBA 11g to Oracle Database 12c — Question 23

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

Answer options

• A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
• B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
• C. by using Active Session History (ASH) data and performing hang analysis
• D. by running ADDM in diagnostic mode

Correct answer: B

Explanation

The correct answer is B because running ADDM allows you to analyze the most recent AWR snapshots, which provides insights into performance issues. Options A and D are not effective for this specific scenario, as they do not utilize the comprehensive historical data available in AWR. Option C, while useful for hang analysis, does not provide the full context needed to diagnose performance degradation.