Oracle
1Z0-054 · Question #125
You look at the Top 5 Timed Events section of the Automatic Workload Repository (AWR) report and find that the wait event buffer busy waits is consuming a significant portion of DB time. What does…
The correct answer is E. block contention on segment headers, data blocks, undo header, or undo blocks. See the full explanation below for the reasoning.
Question
You look at the Top 5 Timed Events section of the Automatic Workload Repository (AWR) report and find that the wait event buffer busy waits is consuming a significant portion of DB time. What does this wait event indicate?
Options
- Abuffer cache too small
- Binsufficient DBWn processes
- Cexcessive block replacement
- Da large number of locally-managed tablespaces in the database
- Eblock contention on segment headers, data blocks, undo header, or undo blocks
How the community answered
(23 responses)- B9% (2)
- C4% (1)
- D4% (1)
- E83% (19)
Community Discussion
No community discussion yet for this question.