Note that the CKPT process does not perform the bulk of the I/O
associated with a checkpoint. That is all handled by the database
writer(s). The CKPT process just takes to job of marking the ckeckpoint
SCN in datafile headers away from the log writer. Although it doesn't
usually take a long time to update file headers, it is a good idea not
to make the log writer interrupt its job of flushing the log buffer for
anything. When the log writer stops doing that, people trying to commit
have to wait.
--
Jeremiah
Bob Beilstein wrote:
>
> In addition to Craig Shallhamer's excellent suggestions, you want to make
> sure that you have:
>
> CHECKPOINT_PROCESS=TRUE
>
> set in your init.ora. This will start a separate process devoted to doing
> checkpoint I/O.
>
> In my experience, it can make the difference between getting the log files
> emptied before you roll back to them, and not.
Received on Thu Mar 02 2000 - 00:00:00 CST
