SGA limit on Solaris x86

From: Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK>
Date: 7 Oct 2008 10:24:26 GMT
Message-ID: <gcfdcq$j4a$1@net44p.hkbu.edu.hk>


Dear all,

I install Solaris 10 x86 and Oracle 10g. I find that oracle can only use 4G memory maximum for SGA. Would anyone know what I miss in order to increase to 8G or more?

Thanks in advance.

--
Johnson Chow

==============================================================
/etc/system: set shmsys:shminfo_shmmax=8589934591
==============================================================
$ projects -l user.oracle projid : 100 comment: "" users : oracle groups : (none) attribs: project.max-sem-ids=(priv,100,deny) project.max-sem-nsems=(priv,256,deny) project.max-shm-ids=(priv,100,deny) project.max-shm-memory=(priv,17179869184,deny)
==============================================================
$ top PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND 820 oracle 1 59 0 4215M 18M sleep 0:00 0.02% oracle 837 oracle 1 59 0 4215M 25M sleep 0:00 0.01% oracle 831 oracle 11 59 0 4216M 23M sleep 0:00 0.01% oracle 839 oracle 1 59 0 4216M 32M sleep 0:00 0.00% oracle 841 oracle 1 59 0 4214M 17M sleep 0:00 0.00% oracle
==============================================================
SQL> show sga; Total System Global Area 4294967296 bytes Fixed Size 2026256 bytes Variable Size 805307632 bytes Database Buffers 3472883712 bytes Redo Buffers 14749696 bytes
Received on Tue Oct 07 2008 - 05:24:26 CDT

Original text of this message