Oracle
1Z0-054 · Question #210
You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the Top 5 Timed Events for your database. Which two options describe what these…
The correct answer is A. Latch:cache buffer LRU chains - indicates excessive block replacement C. Latch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly. See the full explanation below for the reasoning.
Question
You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the Top 5 Timed Events for your database. Which two options describe what these wait events indicate? (Choose two.)
Options
- ALatch:cache buffer LRU chains - indicates excessive block replacement
- BLatch:cache buffer LRU chains - indicates insufficient size of application cursor cache
- CLatch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly
- DLatch:cache buffer chains - indicates that there are several sessions waiting for a buffer that is
How the community answered
(15 responses)- A87% (13)
- B7% (1)
- D7% (1)
Community Discussion
No community discussion yet for this question.