Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LOG_CEHCKPOINT_INTERVAL AND RECOVERY
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 Wed Mar 24 1999 - 12:30:55 CST