Hi ALL,
I am currently studing for 023 using Sybex and do not get everything about log_checkpoint_interv:

*It says "if the redo log file is 1MB, that is 2000 OS blocks [], setting the parameter to 500 will initiate a ckpt when the log file is 1500 blocks full"
I get that : you do (size of the log file -log_checkpoint_interv) and you find where (starting from the beginning of the log file), the chkpt will occur.

* There is question which says :
What does log_checkpoint_interval = 60 means ?
A\ A checkpoint occurs every 60s
B\ A chkpt occcurs after writting 60 blocks.
C\ When instance recovery is required, Orcale need not read more than 60 blocks.
D\ When instance recovery is required, Orcale need not read more than 60 s worth of redo log blocks.

The correct answer is C and I do not get why : I thought ( according to the precedent exemple), that would be 60 OS blocks before the end of the log file. Apart if the log file is 120 OS block, I do not see why the answer C is correct ( apart because the others answers are abviously wrong ).

I did not find to much documentation about this parameter.

Thanks to help me on that.