You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the
Posted: Sun Jun 11, 2023 3:49 pm
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.)
A. Latch:cache buffer LRU chains - indicates excessive block replacement
B. Latch:cache buffer LRU chains - indicates insufficient size of application cursor cache
C. Latch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly
D. Latch:cache buffer chains - indicates that there are several sessions waiting for a buffer that is presently being read into the buffer cache by another session
A. Latch:cache buffer LRU chains - indicates excessive block replacement
B. Latch:cache buffer LRU chains - indicates insufficient size of application cursor cache
C. Latch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly
D. Latch:cache buffer chains - indicates that there are several sessions waiting for a buffer that is presently being read into the buffer cache by another session