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

On Fri, 4 Oct 2002 10:49:40 -0400, "Harry Sheng" <hsheng_at_innovance.com> wrote:

>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
>

This is caused by the 32-bit limit imposed by running a 32-bit version of Oracle.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Oct 04 2002 - 12:26:54 CDT