Re: Large db on linux

"astalavista" <nobody_at_nowhere.com> wrote in message news:45c4c1eb$0$13715$426a74cc_at_news.free.fr...
> Hi,
>
> Is it possible to have VLDB
> ( SGA >= 4 or 5GB or more )
> on linux on intel XEON 32-bits
> I thought the SGA was limited to 2 GB ...
>
> Thanks for your lights ...
>
>

See the following article :
http://www.puschitz.com/TuningLinuxForOracle.shtml#UsingVeryLargeMemory

"In Oracle 10g R2 the SGA size can be increased to approximately 2.7 GB using the smp kernel and to approximately 3.42 GB using the hugemem kernel. The SGA attach address does not have to be changed for that. To accommodate the same SGA sizes in Oracle 10g R1, the SGA Attach Address must be lowered." Received on Sat Feb 03 2007 - 12:26:40 CST