Oracle
1Z0-054 · Question #136
As a DBA, you notice that the response time of your database has degraded. Which two pieces of tuning-related information can you examine in the alert log to identify possible causes? (Choose two.)
The correct answer is A. frequency of log switches B. frequency of block corruption errors. See the full explanation below for the reasoning.
Question
As a DBA, you notice that the response time of your database has degraded. Which two pieces of tuning-related information can you examine in the alert log to identify possible causes? (Choose two.)
Options
- Afrequency of log switches
- Bfrequency of block corruption errors
- Cconcurrent parsing and buffer cache latch contention
- Dthe amount of CPU time spent on database user-level calls
How the community answered
(39 responses)- A79% (31)
- C5% (2)
- D15% (6)
Community Discussion
No community discussion yet for this question.