图解Oracle Checkpoint Queue  

Checkpoint queues contain the dirty buffers that are ordered by the low RBA. There is one file queue per data file containing: Dirty buffers belonging to that file Delayed logged buffers Linking buffer to checkpoint queue: Whenever the low RBA is set for a buffer, the buffer is added to tail of the CKPTQ and appropriate FQ. Removal of buffer from checkpoint queue: The low RBA is cleared when the buffer is added to write batch. When the buffer is written to disk, it is unlinked from the FQ and CKPTQ. Write of hot buffers from CKPTQ is deferred.