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
You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am