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
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:
