Re: Max SGA size in 32 bit Oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 21 Feb 2001 23:04:34 +0100
Message-ID: <lpe89tcmemeq3mnta64l5mbfnvj8e8rs45@4ax.com>

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 - 16:04:34 CST