How can you detect the cause of the degraded performance?

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?

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?

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.

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

goszczu

goszczu

I’m not sure but A sounds better. Can anyone chalenge that?

https://docs.oracle.com/cd/E11857_01/em.111/e11982/database_management.htm
“When the database server experiences performance issues, diagnostic queries could further impact the system. A new feature, called Memory Access Mode, assists you in diagnosing performance-related problems by collecting system statistics even when the database is either slow or hung.”

Reply