Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
It's a lot smaller than that, but you can lower the attach address to
support larger SGAs. Go out to Oracle Metalink and search. There is
a doc out there that will give you instructions on how to lower the
attach address and thereby increase the size of your SGA. You could
also move up to 64-bit Oracle8i. HTH.
Received on Fri Oct 04 2002 - 12:48:09 CDT