Oracle
1Z0-063 · Question #142
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…
The correct answer is B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR). See the full explanation below for the reasoning.
Question
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?
Options
- Aby performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor
- Bby running ADDM to fetch information from the latest Automatic Workload Repository (AWR)
- Cby using Active Session History (ASH) data and performing hang analysis
- Dby running ADDM in diagnostic mode
How the community answered
(43 responses)- A16% (7)
- B72% (31)
- C5% (2)
- D7% (3)
Community Discussion
No community discussion yet for this question.