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