You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply