Re: checkpoint interval

Sahrul, Try dropping your LRU_MIN_DIRTY to 0 and LRU_MAX_DIRTY to 1. This will cause ODS to do more background writes and should reduce your checkpoint time. Also depending on the size of you buffer cache you may need to increase the LRUS. I would try 16 or 32. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: checkpoint interval Author: Sahrul Hidayat <Sahrul_Hidayat@fmi.com> at WCA-INET Date: 24/4/98 10:22 AM Dear All, I'm running INF 7.23UC1 with total database is 76 GB. We are happy with our configuration, but since Last Monday, our online perfomance going down and also interval of checkpoin sometime took so long, about 50-170 second. We have checked no big transaction, no long transaction that caused checkpoint interval like this. all transaction is on normal condition. Could somebody give some suggestion, what are the parameter relation with checkpoint interval, what is exacly the problem, if we face problem like this ? here is our online param : LRUS = 8 CLEANER=12 LRU_MAX_DIRTY=3 LRU_MIN_DIRTY=1 reply and suggestion are greatly appreciated...... rgds sahrul