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.
--
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com
Received on Fri Oct 04 2002 - 12:33:18 CDT
