If you set LOG_CHECKPOINT_INTERVAL = 500,
OS Block Size is 512 Bytes and
the redo log file size is 1MB, then for every 256,000 bytes written in the redo log file, checkpoint will occur.

Also note down, if Logical Volume Manager is configured, then LVM OS Block Size will override the OS Block Size.

There is no formula.
Just set LOG_CHECKPOINT_INTERVAL=1500 so that when even 3/4th of redo is filled, checkpoint will occur.



[Edited by tamilselvan on 03-14-2002 at 04:16 PM]