Which two options describe 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 0

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