Re: log_checkpoint_timeout : what is exactly the meaning ?

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Fri, 31 May 2002 11:24:06 -0500
Message-ID: <ad8829$hu7$1@news.gte.com>

> Sorry for my insistance, but it's still not clear to me. Does what you say
> mean that checkpoints are always completed in exactly 15 minutes (in case
> there is a low traffic, so that redo log switch occur in more than 15') ?

More like a running window of roughly 900 seconds worth of changes in the checkpoint queue?

Those blocks that exceed the 900 seconds and therefore are at the "end" of the queue, are written to disk outside of a checkpoint. Effectively throttling the amout of work required at the next checkpoint.

-Kevin Received on Fri May 31 2002 - 11:24:06 CDT