Re: SGA Sizing on Sun

the largest SGA I've been able to run a v8 db on 32bit Solaris is 3G...you will need to remap the start sga address and relink the oracle kernel to do this. You're also limited in the subcomponents of the SGA to at most 2G. This db had ~2G variable and ~1G db block buffer (we were running MTS).

You could conceivable have two 1.7G SGA, but that would mean two instances and two separate databases on the same box.. You will be constrained ultimately by the amount of shared mem your Solaris box can support, which under the 32bit env I believe is 4G.

jc

mkb wrote:

> Folks,
>
> Say I have 6Gb of physical RAM using Solaris 2.6 (32-bit) and
> Oracle 8.0.5 (32-bit). I have seen numbers quoted as to the
> maximum size of an SGA being no bigger than 1.7Gb. Also, I've
> seen a range quoted of an SGA being in the range of 40-60% of
> total physical RAM. My question is, if I have 6GB of physical
> RAM, can I have two SGA each of 1.7Gb?
>
Received on Thu Apr 06 2000 - 00:00:00 CDT