Re: LOG_CEHCKPOINT_INTERVAL AND RECOVERY

Dear Devinder,
If your checkpoints will occur more frequently then the log switch , that means the DBWR
will write more frequently to the disk , thus generating less redologs, so if a recovery has to be made,
since most of the data changed is available on the disk, there is no need to apply large number of redologs, thus reducing the recovery time

Nilima.

Devinder Pal Singh wrote:

> Dear all,
> This is regarding the log_cehckpoint_interval, It is said that if you
> want faster recovery, or smaller granularity of recovery, this
> parameter
> should be set to some value smaller than the size of your redo log
> file.
> My question is how does it help in recovery. Whenever a chekpoint
> happens, either explicit or implicit, it signals DBWR to flush the
> buffers to disk and after the DBWR finsihes then either LGWR or CKPT(
> if
> it is present) update the datafile headers and controfile, So how
> does
> recovery come into picture. Can somebody explain this.
> Regards
> Davinder
Received on Thu Mar 25 1999 - 14:36:26 CST