Re: Largest Oracle 8.1.7 SGA on AIX 32bit (4.3.3)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 25 Mar 2003 00:51:18 -0800
Message-ID: <a20d28ee.0303250051.1e3c565e@posting.google.com>

"computer person" <fake_address_at_nothing.com> wrote in message news:<9mQfa.61281$Dt1.48417_at_news02.bloor.is.net.cable.rogers.com>...
> Does anyone know what is the maximum shared segment size on AIX 4.3.3
> (32bit) for Oracle 8.1.7 (32bit) or where I might find that info?
>
> Thanks

32-bit architecture means the maximum segment size is 2G.

However Oracle recommends using only one third of physical RAM to avoid paging. As a 32-bit processor can address 2G of memory, that would mean 666 Mb. You'd better tune the application first.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Mar 25 2003 - 02:51:18 CST