Hi,
You can set this with two parameters one is 1.LOG_CHECKPOINT_INTERVAL and 2.LOG_CHECKPOINT_TIMEOUT.
Second one works depending on the number of seconds that u set to checkpoint to occur,u set this in the parameter file.
First one specifies that many number of filled OS blocks to be written to the database




Reply With Quote