checkpoint interval
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