Re: Please Help DB Buffer Cache Size

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 17 Aug 2005 02:00:29 GMT
Message-ID: <Xns96B4C15DC2C30SunnySD@68.6.19.6>

brijeshmathew_at_gmail.com wrote in
news:1124210929.584575.32060_at_g44g2000cwa.googlegroups.com:

> Frank
>
> My current buffer size is 140 MB.

I believe you.

> I am having performance issues.

I believe you.

> That is the reason I am doing this.

What a faulty leap of mis-logic.
You are guilty of the READY, FIRE, AIM school of "tuning". You really have no good handle on what is wrong, but you are ready to throw resources (RAM) at the problem & hopes the problem goes away.

Rhetorical question - what happens next time you turn on Buffer Cache Advice with different SQL running and your symptoms have morphed into a different gremlin? Received on Tue Aug 16 2005 - 21:00:29 CDT