Re: 2GB limit for SGAs

chloe.crowder_at_bl.uk (Chloe Crowder) wrote in message news:<f27559a3.0405260814.4aa762_at_posting.google.com>...
> 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?
>
> I quite understand that there's a architectural limit per SGA, but I'm
> really surprised about a total limit.

It is more complicated than that, there are a number of notes on metalink that explain the issues. In a word, no.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1025876.6 notes that the 2G limit is for Solaris 2.4, with a patch available. 64 bit OS's tend to not have these issues.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=61896.1&p_database_id=NOT explains the older concepts fairly clearly, although points elsewhere for 8i detailed instructions.

http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=62290.1 notes how to upgrade your O to 64 bit.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=107201.1 is specific to hp, but has some interesting thoughts.

jg

--
@home.com is bogus.
"See my DBA?  Larry said I don't need one anymore!"