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

From: Doug Smith <dsmith_at_gulfaero.com>
Date: 1996/06/06
Message-ID: <dsmith.129.000F2EC4_at_gulfaero.com>#1/1


In article <4p6vgn$3am_at_news2.cais.com> duffy_at_cais.cais.com (MCC) writes:
>From: duffy_at_cais.cais.com (MCC)
>Subject: [Q] Increase SGA, increase performance ???
>Date: 6 Jun 1996 16:03:35 GMT
 

>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.

I don't work with Sun's just hp and ibm, however, my workstation has 128meg ram! It's hard to imagine why you would have 4 cpu's with only 128 meg ram?

About the SGA, you have to look at performance numbers to determine sizes. Yes, if a buffer increase (increases the SGA) reduces the number of physical I/O's, then it will increase performance.

A fairly easy way to experement is to change the setings in the init?.ora file to the oracle suggested small, med, large settings, then measure your performance. They are just guesses, but that's all you can do anyway without real performance analysis. Received on Thu Jun 06 1996 - 00:00:00 CEST

Original text of this message