Re: Max SGA size in 32 bit Oracle

Sybrand, thanks.
I understand the guidelines, but is it possible, say on a 16GB Memory machine would you be able to allocate more than 2.5 GB to the SGA? (we have some very large buffer_pool_keep requirements) I have read on a 32 bit Oracle installation, 1.74GB is max, unless you remap the SGA in the kernel, and then you are allowed up to 2.5GB.

Sybrand Bakker wrote:

> On Wed, 21 Feb 2001 10:14:37 -0800, "kipnukdog
> <kipnukdog_at_netscape.net" <"NO SPAM>"> wrote:
>
> >I remember reading somewhere that there is a maximum size you can
> >allocate for Oracle SGA running 32 bit mode (In this case it would be
> >8i).
> >
> >Is this true?
> >
> >I saw the following figures, which would be the maximum after re-mapping
> >the SGA in the Unix Kernel.
> >
> >SGA Maximum.
> >Oracle7 (32bit) 2.25GB
> >Oracle8 (32bit) 2.5GB
> >Oracle8 (64bit) Upper limit greater than possible physical memory
> >
> >
> >Thanks.
> >
> >
>
> Guideline is no more than one third of physical ram, otherwise you
> will force the server to fault.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
Received on Wed Feb 21 2001 - 19:11:30 CST