Forcing a Full Checkpoint

You might want to force a full checkpoint for any of the following reasons, as well as others:

• You have just finished building a large index. If the database server terminates before the next checkpoint, the index build will restart the next time that you initialize the database server.
• You are about to attempt a system operation that might interrupt the database server. If a checkpoint has not occurred for a long time, fast recovery could take longer than you want.
• Foreground writes are taking more resources than you want. You can manually force a checkpoint to bring this down to zero for a while.

To force a checkpoint, execute the following command from the command line:

onmode -c