Re: Please Help DB Buffer Cache Size

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 16 Aug 2005 12:50:45 +0200
Message-ID: <ddsg11$fag$1@news1.zwoll1.ov.home.nl>

brijeshmathew_at_gmail.com wrote:
> 189.668 48555 0.9746 30493991
> 204.2578 52290 0.9727 30434138
> 218.8477 56025 0.4692 14680325
> 233.4375 59760 0.2988 9348170
> 248.0273 63495 0.2699 8445659
> 262.6172 67230 0.2656 8309936
> 277.207 70965 0.2637 8251755
> 291.7969 74700 0.2621 8201407
>
> Should I increase my DB Buffer Cache to 250 MB in this case, or I am
> not understanding it properly.
> Please Advice
>

Should you? Are you having performance complains, or do you have sub second response times on all queries?

If not, you might try upping the buffer to some 230MB; not much gain (< 3%) in the 230 - 250M increase

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Tue Aug 16 2005 - 05:50:45 CDT