Re: 2GB limit for SGAs

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<jb5ab05p1qctpjmeg4e732di8up8618ct7_at_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.
> >

Thanks for this, but I think there's been a misunderstanding. I've inherited a system with two databases (each with a single Oracle instance) under 32-bit Oracle, and am not in a position to alter this in the short term. One of the instances has an SGA of 1.7GB, and the other of 0.3GB. When I queried the discrepancy with the third-party supplier I was told that the total of the two SGAs could only be 2GB. I would have assumed that the two areas were completely independent, and that two instances each with up to 2GB SGA were possible. This is what I'm trying to clarify.

Chloe Crowder Received on Thu May 27 2004 - 03:54:33 CDT