图解Oracle Checkpoint Queue

2012/02/03 by Leave a Comment

图解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.

Filed Under: Oracle

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号