Re: SGA limit on Solaris x86

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