Re: SGA

On Thu, 19 Sep 2002 18:27:40 +0800, "xueyang" <xueyangy_at_singnet.com.sg> wrote:

>One simple question, Is it the larger the size of SGA is, the better
>performance we get?
>
>

Why are simple questions not similarly simple to answer ....?

Blindly increasing the SGA *may* increase performance, but that is a very unstructured way of tuning your system and any performance gain from this is "pure luck". You may even experience performance loss by increasing the SGA size....

To learn how to attack the problem in a structured way, read the " Oracle9i Database Performance Guide and Reference".

• Kenneth Koenraadt