Re: 2GB limit for SGAs

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 27 May 2004 00:11:08 +0200
Message-ID: <jb5ab05p1qctpjmeg4e732di8up8618ct7@4ax.com>

On 26 May 2004 09:14:42 -0700, chloe.crowder_at_bl.uk (Chloe Crowder) wrote:

>Hi
>
>We're running 32-bit 8.1.7 on 64-bit SunOS 5.8. We have two databases
>and one Oracle installation. Someone has been trying to tell me that
>there is a 2GB limit on the total size of the SGA, i.e. (database 1
>SGA + database 2 SGA) must be less than 2GB. Is this correct?

32 bit sw cannot address more than 2Gb of memory. However, running properly designed databases, should never this amount of SGA.

You may also ask yourself why you are running 32 bit Oracle on a 64 bit O/S, as 64-bit 8.1.7 does exist, and the only thing you need to do is to order the CD by means of iTar.

>
>I quite understand that there's a architectural limit per SGA, but I'm
>really surprised about a total limit.
>
>Chloe Crowder
>The British Library

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed May 26 2004 - 17:11:08 CDT