Oracle
1Z0-063 · Question #128
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…
The correct answer is C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest. See the full explanation below for the reasoning.
Question
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?
Options
- AEnable Memory Access Mode, which reads performance data from SGA.
- BUse emergency monitoring to fetch data directly from SGA for analysis.
- CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest
- DUse Active Session History (ASH) data and hang analysis in regular performance monitoring,
- ERun ADDM in diagnostic mode.
How the community answered
(23 responses)- A4% (1)
- B13% (3)
- C74% (17)
- D9% (2)
Community Discussion
No community discussion yet for this question.