what these wait events indicate?

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.)

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is right. Latch: Cache Buffer LRU Chain waits indicates excessive block replacement
B is wrong.
C is right. Latch: Cache Buffer Chain waits indicates repetitive block access.
D is wrong.