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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------