Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to allocate >2GB to SGA

RE: How to allocate >2GB to SGA

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Tue, 16 Jan 2007 14:31:19 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E0272B@ex2003.metratech.com>


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-l
Received on Tue Jan 16 2007 - 13:31:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US