By default, Windows imposes a 2g per process limit on all processes
including the OS itself. Oracle runs as a process with each session running
as a thread within that process so the entire Oracle process including SGA,
sessions, DLLs, executables, etc. must all fit within 2g. There is a
boot.ini switch that raises the limit to 3g while reducing the OS's
addressable memory to 1g.
I can't speak to other 32 or 64 bit platforms from experience as I've never
tried to push any of them to the limit.You need to remember though that
X-bit processor doesn't necessarily mean X-bit addressability. Unless I'm
mistaken the bit size of a processor represents the size of the registers,
instructions and internal busses, but not the memory addressability which is
limited by other things in the hardware. Having said that, current 32 bit
platforms can usually addresses 4g.
--
Chuck
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, February 28, 2003 12:34 PM
> Hello,
>
> 1) How big (max) can an Oracle SGA be in a 32bit platform (Windows and
> Linux on ia32)?
>
> 2) How big (max) can an Oracle SGA be on a 64bit platform (Sparc
> Solaris, AIX PowerPC)?
>
> Thanks.
>
> --
> Lyndon Tiu
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Lyndon Tiu
> INET: ltiu_at_alumni.sfu.ca
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: chuckh_at_softhome.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Feb 28 2003 - 13:09:26 CST
