Re: SGA

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 19 Sep 2002 21:06:00 +1000
Message-ID: <V1ii9.35857$g9.102252@newsfeeds.bigpond.com>

Hi Xueyang,

It depends.

Are the current SGA memory structures sufficiently sized for optimum database performance ? If not, then increasing would be beneficial. If so then increasing would either be of no benefit or possibly detrimental to database performance.

Remember, the SGA is comprised of many memory structures, the shared pool, the various db buffer caches, the redo log buffer, the large pool, the java pool, blah blah blah ... Each of these structures needs to be appropriately sized and tuned. If sized too small, then performance will suffer. However, it sized too big, in the majority of cases, this could adversely effect performance.

They need to be sized 'right' and hence so does the SGA.

In answer to your question, no, more is not necessarily better.

Cheers

Richard
"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:amc8ju$vha$1_at_mawar.singnet.com.sg...
> One simple question, Is it the larger the size of SGA is, the better
> performance we get?
>
>
Received on Thu Sep 19 2002 - 06:06:00 CDT