Oracle Database 12c: Advanced Administration — Question 27

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 to access the latest AWR snapshots provides historical performance data that can pinpoint issues. Option A focuses on real-time monitoring, which may not give a complete picture of past performance. Option C, while useful, does not offer the comprehensive overview that AWR provides. Option D does not specify the use of AWR data, making it less effective for diagnosing performance problems.