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:

Zhu Chao
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: