Long transaction & LOG_CHECKPOINT_INTERVAL

Why we say LOG_CHECKPOINT_INTERVAL ensures that no more than log_checkpoint_interval number of redo blocks are read during instance recovery.

Checkpoint only ensures those dirty pages in buffers will be written to disk. If there is a long transaction which will span more than one log file. During the instance recovery, there are maybe more than log_checkpoint_interval will be need to be read.

Would you tell me where my understanding is wrong?

TIA Received on Mon Jun 03 2002 - 21:46:03 CDT