RE: How to allocate >2GB to SGA

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