RE: How big SGA for 32GB RAM

10.2.0.1 on 32 bit RHAT4

Question is more of a MAX SGA allowed in this context.

I will play will all the values but is good to know the max and recommened(What others are using) values  

From: David Sharples [mailto:davidsharples_at_gmail.com] Sent: Thursday, January 18, 2007 3:44 PM To: Harvinder Singh
Cc: oracle-l
Subject: Re: How big SGA for 32GB RAM  

version of oracle, operating system, 32 or 64 bit  

details .....  

but how about working out what you need instead of just guessing, a 1Gb shared_pool is large, how much sql do you have?  

how much data are you dealing with  

On 18/01/07, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org > wrote:

Hi,

We were installing oracle on 32GB RAM server and configured the Shared_pool to 1GB and PGA to 3GB, so wondering what the maximum numbers

of memory can be allocated for buffer cache or How much memory OS needs since rest can be used by database instance. In SQL Server normally we allocate 30GB for database and 2GB for OS.

--
http://www.freelists.org/webpage/oracle-l