Here is one more head proning topic.
With respect Oracle 8i
If the redo log file size is 1MB,that is 2000 OS blocks; if the OS block size is 512 KB,then setting the parameter log_checkpoint_interval to 500 will initiate a checkpoint when the redo log file is 1500 blocks full.
Now my question:Is there any formula to caluculate it?.I tried most possible methods to get 1500 and Hmmmm,I could not succeed.
Ok After writing 256000 bytes to Redo logfile Check Point Occurs.
Hint : 500 * 512.
But in the Book he says setting parameter to 5oo will initiate a checkpoint when redolog file is 1500 blocks full.