Re: SGA limit on Solaris x86
Date: Tue, 7 Oct 2008 03:18:50 -0700 (PDT)
Message-ID: <e7099ecd-39b9-4491-b524-1d259be925a9@f77g2000hsf.googlegroups.com>
On 7 okt, 12:24, "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
Bumping up the SGA has never been a remedy to resolve performance
problems.
Tuning SQL is.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Oct 07 2008 - 05:18:50 CDT