Re: SGA limit on Solaris x86
Date: Tue, 7 Oct 2008 03:08:39 -0700 (PDT)
Message-ID: <cfd89852-31fa-4c7d-850a-24331cd68de6@k13g2000hse.googlegroups.com>
On Oct 7, 2:24 pm, "Mr. Chow Wing Siu" <wsc..._at_Comp.HKBU.Edu.HK>
wrote:
> 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
I believe you need to use 64-bit (x86-64), both OS and Oracle, to go beyond 4G. I'm not sure if indirect data buffers are available on Solaris x86, but even if they are, you will only be able to use the extra RAM for the buffer cache anyway.
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Tue Oct 07 2008 - 05:08:39 CDT