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?

Question

Accepted Answer

A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor

Answer

B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR)

Answer

C. by using Active Session History (ASH) data and performing hang analysis

Answer

D. by running ADDM in diagnostic mode

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…

Question

Options

How the community answered

Explanation

Topics

Community Discussion