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: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 16 Jan 2007 14:34:23 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF270AEB3D63@AABO-EXCHANGE02.bos.il.pqe>


What architecture? 32 or 64 bit? Is the kernel 32 or 64 bit?

Hint: Check output of uname -a
If you see something like this:
Linux plinrac1.pre.il.pqe 2.6.9-42.0.2.ELsmp #1 SMP Thu Aug 17 17:57:31 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux

Then it's 64-bit. (Note the "x86_64" near the end of the above line.)

If you see something like this:
Linux prepqfep1 2.4.21-27.0.2.ELsmp #1 SMP Wed Jan 12 23:35:44 EST 2005 i686 i686 i386 GNU/Linux'

Then it's 32-bit. (Note the "i686" near the end of the above line.)

-Mark
--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be done at all. -Peter F. Drucker, 1909-2005

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, January 16, 2007 2:04 PM
To: oracle-l
Subject: How to allocate >2GB to SGA

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:34:23 CST

Original text of this message

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