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@xxxxxxxxx] 
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@xxxxxxxxxxxxx
<oracle-l-bounce@xxxxxxxxxxxxx > 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.

Other related posts: