1Z0-060 · Question #1
You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the…
The correct answer is B. Use emergency monitoring to fetch data directly from SGA analysis. When an Oracle database is hanging and normal connections fail, emergency monitoring reads SGA data directly without requiring a standard database connection, enabling diagnosis without a restart.
Question
You notice that the performance of your production 24/7 Oracle database 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?
Options
- AEnable Memory Access Mode, which reads performance data from SGA.
- BUse emergency monitoring to fetch data directly from SGA analysis.
- CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic
- DUse Active Session History (ASH) data and hang analysis in regular performance monitoring.
- ERun ADDM in diagnostic mode.
How the community answered
(29 responses)- B79% (23)
- C7% (2)
- D10% (3)
- E3% (1)
Why each option
When an Oracle database is hanging and normal connections fail, emergency monitoring reads SGA data directly without requiring a standard database connection, enabling diagnosis without a restart.
Memory Access Mode also reads from the SGA but is a standard OEM monitoring mode that still depends on a functional connection path, making it ineffective when the instance is in a hung state.
Emergency monitoring in Oracle Enterprise Manager is specifically designed for hang and severe degradation scenarios - it bypasses the normal listener and server process path to read diagnostic data directly from the SGA, making it the only option that works when standard connections cannot be established.
ADDM analyzes data from AWR snapshots and requires a functional database connection to be invoked - it cannot operate when the database is hanging and connections time out.
Regular performance monitoring via ASH and hang analysis in OEM requires a working database session, which is unavailable when the instance is not accepting connections.
There is no Oracle-supported mode called 'ADDM in diagnostic mode' - this is not a valid invocation method for the Automatic Database Diagnostic Monitor.
Concept tested: Oracle emergency monitoring for hung database instances
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tdppt/monitoring-real-time-database-performance.html
Topics
Community Discussion
No community discussion yet for this question.