Re: [Q] Increase SGA, increase performance ???

In <4p6vgn$3am_at_news2.cais.com>, duffy_at_cais.cais.com (MCC) writes:
>We have SUN SParc 1000E (SOlaris 2.5) with Oracle 7.2.3 installed. This
>SUN UNIX computer have 4 CPU and 128 MB RAM (Total). The SGA currently
>setup size "8386600" and the database size is 1.5GB (total datafiles). I
>don't know the SGA size is big enough or not? If I increase SGA size,
>will it increase performance? How big SGA size is good value? Do I need
>put more RAM or not? Thank you for help.
>

Don't increase it too much - you can cause the machine to start 'swapping' the SGA out to disk and this would be very detrimental to performance

Bye,

Steve

opinions expressed are mine and do not
necessarily represent those of my employer Received on Fri Jun 07 1996 - 00:00:00 CEST