Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to allocate >2GB to SGA
We installed the 32 bit but I now I found the the following document and
it looks like we can go until 64GB even with 32 bit after configuring
few parameters:
http://www.puschitz.com/TuningLinuxForOracle.shtml#SettingSHMMAXParamete
r
Let me know if someone have experience using large SGA on 32 bit linux.
-----Original Message-----
From: dtseiler_at_gmail.com [mailto:dtseiler_at_gmail.com] On Behalf Of Don
Seiler
Sent: Tuesday, January 16, 2007 2:13 PM
To: Harvinder Singh
Cc: oracle-l
Subject: Re: How to allocate >2GB to SGA
Are you on a machine with 32-bit CPUs?
Don.
On 1/16/07, oracle-l-bounce_at_freelists.org
<oracle-l-bounce_at_freelists.org> wrote:
> Hi,
>
> We just installed the Oracle on the Linux RedHat 4 having 32GB memory,
> but somehow I am not able to allocate >2GB to SGA. I changes the
> SGA_MAX_SIZE to 10GB and now when try to restart Oracle getting error
:
> SQL> ALTER SYSTEM SET sga_max_size = 10737418240 SCOPE=SPFILE;
> System altered.
> SQL> shutdown immediate
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup
> ORA-27102: out of memory
>
> Thanks
> --Harvinder
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 16 2007 - 13:31:19 CST
![]() |
![]() |