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

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

Answer options

• A. Enable Memory Access Mode, which reads performance data from SGA.
• B. Use emergency monitoring to fetch data directly from SGA for analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
• E. Run ADDM in diagnostic mode.

Correct answer: C

Explanation

The correct answer is C because running ADDM leverages the Automatic Workload Repository (AWR) snapshots to provide insights into performance issues without needing to restart the database. The other options either do not provide comprehensive performance analysis or require the database to be in a state that may not yield useful information.