These messages in given alert log were full checkpoints caused by log
Incremental checkpoint is an ongoing process, there really isn't a number of
them - in essence it's just CKPT process checking how far DBWR is with it's
writings and updating this info in controlfiles every 3 seconds.
*Incremental* checkpoint entries in alert log are just status messages on
checkpoint progress as far as I know, not individual checkpoint completion
----- Original Message -----
From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
Cc: <exriscer@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, May 24, 2006 7:50 PM
Subject: Re: checkpoint over 15 minutes?
Well, it's also a function of fast_start_mttr_target so reducing it
should lead to more frequent and short checkpoints. On the other hand,
it might stress IO subsystem more and give actually an opposite