RE: How big SGA for 32GB RAM

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: "David Sharples" <davidsharples@xxxxxxxxx>
  • Date: Thu, 18 Jan 2007 16:06:44 -0500 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: 


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: