Re: no checkpoint

Franklin Tang wrote: > Dear All, > I just want to know if I set the CKPTINTVL to 36000 which an hour, of > coz I have around 512 LRU to flush my buffer. Then what will be drawback for > my system. As has been pointed out, 36000 seconds is 10 hours. Why do you want to do this? If you tell us your problem we may be able to help. My advice is don't do it. Set it to about 300. Not least the fact that your checkpoint duration may be affected, but your page cleaner performance definitely will, doing more LRU writes. Either your logical or physical logs will probably force a checkpoint long before your 1 (10?) hour is up anyway. Your fast recovery times may well be affected also, depending on how large your logs are. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+