Re: Combined SGA size and Total Memory

Simply try and see. No rule of numb.
I have an Oracle instance having 12G SGA and 800 connections. Oracle
SGA+PGA size is about 14GB. The total memory for this box is 16GB.

According to those rule of numb, I am totally wrong. I am using 75% of
physical memory for the SGA.  But I am happy with this. (Yes, it is an
OLTP system), so pga is relatively small.

No pagein/pageout/swapin/swapout, kernel cpu usage is below 8%.If I
only use 35% of the total memory for sga, what is the use of the
remaining physical memory?
 
On Wed, 23 Jun 2004 20:37:10 -0400, Mladen Gogala <gogala@xxxxxxxxxxxxx> wrote:
> 
> 

-- 
Regards
Zhu Chao
www.cnoug.org
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: