Re: Combined SGA size and Total Memory

From: zhu chao <zhuchao_at_gmail.com>
Date: Thu, 24 Jun 2004 08:57:30 +0800
Message-ID: <962cf44b04062317573fa54d96@mail.gmail.com>

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_at_sbcglobal.net> 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_at_freelists.org
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
-----------------------------------------------------------------

Received on Wed Jun 23 2004 - 19:54:16 CDT