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

"Pablo Sanchez" <pablo_at_dev.null> wrote in message news:Xns929D7662E323Epingottpingottbah_at_209.189.89.243...
> Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in
> news:bpjrpugb5enrm63fl4hpo2n9j4068mq8mm_at_4ax.com:
>
> > 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.
>
> More to the point, _any_ 32-bit application is limited to an address
> space of 2G unless a translation table is used and multiple shared
> memory segments are used to coalesce memory. Not pretty, the way to
> go for large memory models is to use a 64-bit application.

Or failing that, implement a RAC.

;-)
HJR
> --
> Pablo Sanchez, High-Performance Database Engineering
> http://www.hpdbe.com
Received on Fri Oct 04 2002 - 15:51:40 CDT