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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
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


Other related posts: