Re: what is the side effect of setting checkpoint interval very large??

yes, commit (and when DBWR have to clean buffers for a checkpoint, ...) causes LGWR to write log buffers to the redo logs.

log_checkpoint_interval indicates the number of redo blocks the DB has to fill before a checkpoint occurs;
I think that a very large value (it should be larger than your larger redo log) doesn't matter, as the log switch then only occur when redo logs are full.

"zhanggp" <zhangguoping_at_boco.com.cn> a écrit dans le message news: b4s9kr$14e0$1_at_mail.cn99.com...
> thks!
> and by the way, can commit cause LGWR write log buffers to redo log files?
>
>
Received on Fri Mar 14 2003 - 05:10:14 CST