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

From: Harry Sheng <hsheng_at_innovance.com>
Date: Fri, 4 Oct 2002 10:49:40 -0400
Message-ID: <2Zhn9.14521$H67.66857@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 Received on Fri Oct 04 2002 - 09:49:40 CDT

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US