Architecture and Administration Q014

What happens next when a server process is not able to find enough free buffers to copy the blocks from disk?



1. Signals the CKPT process to clean up the dirty buffers.
2. Signals the SMON process to clean up the dirty buffers.
3. Signals the CKPT process to initiate a checkpoint.
4. Signals the DBWn process to clean up the dirty buffers.



Answer 4 - To reduce disk I/O contention, the DBWn process does not write the changed buffers immediately to the disk. They are written only when the dirty buffers reach a threshold or when there are not enough free buffers available or when a checkpoint occurs.