Re: Physical Log size

as for OLTP environment you should set the LRU_MAX_DIRTY to 80 and LRU_MIN_DIRTY 70 so that the MLRU will be flushed to disk in between checkpoints. Setting the gap in between them smaller will encourage more LRU_WRITE and when comes to checkpoint it will have less work to do BT, you have 24 cleaners is more than sufficient. Regards, --- "Link, David A." <DALink@West.com> wrote: > I have an OLTP database which I need to keep the > checkpoints below 5 > seconds, however, my users need to load millions of > records periodically. > The database needs to be available 7x24. I have > LRUMIN=0 and LRUMAX=1. My > checkpoints still jump up during a load. My current > physical log is 80 meg > in size. Are there any caveats to making this 500 > meg, so I can avoid > reaching the 75% thresh hold? > > Addition information is LRUS=24,CLEANERS=24. > > Is there anything else which I should try? > > My data is striped accross 8 drives and mirrored. > When the dirty buffers are > flushed how is this handled? I have 1 dbspace and I > am wondering if that is > making the flushing single threaded. > > Is there anything else I should be looking at? > > iostat shows no hot disks. > > All help is appreciated. > TIA > > David Link > ===== __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com