How to allocate >2GB to SGA

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 16 Jan 2007 14:04:15 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E02729@ex2003.metratech.com>

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 Received on Tue Jan 16 2007 - 13:04:15 CST