Re: CHECKPOINTS

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.