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

In article <4p6vgn$3am_at_news2.cais.com>, MCC <duffy_at_cais.cais.com> 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

         Are you running parallel server?

>setup size "8386600" and the database size is 1.5GB (total datafiles). I

        How is your cache hit ratios for buffers, dictionary and library?

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

	It is difficult to say what will help you.  What you need to do is
		- Check for disk swapping
		- Check Cache Hit Ratios
		- Check Physical Disk IO
		- Check what type of optimization (Rule based/Cost Based)

Oracle has A LOT of things that can effect perfomance including Chained Rows, Free Chunks, extents, not enough "Parking slots" in data blocks etc. Give us some more information on what you have already done and what you have.

--
-------------------------------------------------------------------------------
Mark E. Porterfield
porterf_at_primenet.com
The Deloitte & Touche Consulting Group