Re: Upper limit of total SGA for 32-bit Oracle8i Release 3 on 64-bit Solaris 8

"Harry Sheng" <hsheng_at_innovance.com> wrote in message news:<2Zhn9.14521$H67.66857_at_tor-nn1.netcom.ca>...
> Hi,
>
> Is 2GB the upper limit of total SGA size for 32-bit Oracle8i Release 3 on
> 64-bit Solaris 8 ?
>
> I have 8 GB physical memory on my 64-bit Solaris 8 box, the swap size is
> 32GB.
> the shmsys:shminfo_shmmax is set to 4294967295 in /etc/system.
>
> If I set my database db block buffer size to 2GB, I got ORA-27123 error.
> I guess this is caused by the 32-bit system 2GB limit ?
>
> H.S

You may need to adjust sgabeg attach address. Check DocId 61896.1 on Oracle Metalink for more info.
http://metalink.oracle.com/

/Rauf Sarwar Received on Fri Oct 04 2002 - 15:24:01 CDT