Re: Combined SGA size and Total Memory
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 24 Jun 2004 08:57:30 +0800
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
-----------------------------------------------------------------
Other related posts:
