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?
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?
In a critical performance degradation scenario where the database instance may hang and prevent connections, immediate and real-time analysis is essential. Performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) allows you to fetch data directly from the System Global Area (SGA) for quick analysis. This real-time approach is more effective in diagnosing immediate performance issues compared to relying on snapshot-based tools such as AWR, which may not capture the real-time state of the system at the moment of the issue.
correct answer is A