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

duffy_at_cais.cais.com (MCC) wrote:

>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.
If I read this correctly, you've got a 4-CPU SparcCenter 1000 with (only) 128MB of RAM and you've allocated about 2/3 of your physical memory to the SGA? I strongly suggest you review the Oracle7 Installation and Configuration Guide for your platform where I'm sure you'll find a recommendation that the SGA not exceed 1/3 of physical memory.

As far as SGA sizing is concerned, bigger is not always better. Its size is determined by how the instance is to be used, ie., the application. Read the Oracle7 Server Reference Guide section that describes init.ora parameters db_block_buffers, shared_pool_size, and sort_area_size. That will at least get you started.

Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation. Received on Fri Jun 07 1996 - 00:00:00 CEST