Re: Tuning SGA

From: Thomas Day <tomday2_at_gmail.com>
Date: Wed, 23 Mar 2005 11:38:39 -0500
Message-ID: <a8c5045905032308382ac0687d@mail.gmail.com>

I would run STATSPACK and only make changes in response to specific problems. It's nice to have the growth area for when you need it.

There was a discussion a while ago to the effect that just throwing a faster CPU or a larger SGA at a problem without diagnosing a specific fix can sometimes make the problem worse.

If it ain't broke, don't fix it.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 23 2005 - 11:42:35 CST