RE: How to allocate >2GB to SGA

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <Harvinder.Singh@xxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 16 Jan 2007 14:34:23 -0500

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 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 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
Sent: Tuesday, January 16, 2007 2:04 PM
To: oracle-l
Subject: How to allocate >2GB to SGA


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




Other related posts: