Multiple choice technology databases

Under what situation buffer busy wait event occur?

  1. NO FREE BUFFERS

  2. NOT ENOUGH SPACE IN DB CACHE

  3. CONCURRENT ACCESS BY USERS

  4. DIRTY BUFFER ARE NOT CHECKPOINTED
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Buffer busy waits occur when multiple sessions attempt to read or modify the same data block concurrently in the buffer cache. It's a contention issue, not a space or free buffer problem. Dirty buffer checkpointing affects write performance, not read contention.

Keep practicing — related questions