Re: SGA limit on Solaris x86

On 7 okt, 13:27, "Mr. Chow Wing Siu" <wsc..._at_Comp.HKBU.Edu.HK> wrote:
> Mr. Chow Wing Siu <wsc..._at_Comp.HKBU.Edu.HK> wrote:> Is it the problem?  What is sga_target and sga_max_size?
> > How to increase?
>
> ----------------------------------------------
>
> SQL> alter system set sga_target = 0 scope = spfile;
>
> $ top
>    PID USERNAME LWP PRI NICE  SIZE   RES STATE    TIME    CPU COMMAND
>   2281 oracle     1  59    0  283M  190M sleep    0:00  0.18% oracle
>   2246 oracle    23  29   10  186M   75M sleep    0:17  0.01% java
>   2198 oracle    11  59    0  284M  184M sleep    0:00  0.01% oracle
>   1634 oracle     6  59    0   27M   16M sleep    0:02  0.01% emagent
>   2188 oracle     1  59    0  283M  180M sleep    0:00  0.00% oracle
>   2262 oracle     1  59    0  284M  192M sleep    0:00  0.00% oracle
>   2204 oracle     1  59    0  283M  186M sleep    0:00  0.00% oracle
>   1233 oracle     1  59    0 9508K 7776K sleep    0:00  0.00% perl
>   2196 oracle    11  59    0  294M  180M sleep    0:00  0.00% oracle
>   2190 oracle     1  59    0  281M  177M sleep    0:00  0.00% oracle
>   2208 oracle     1  59    0  282M  178M sleep    0:00  0.00% oracle
>   2252 oracle     1  59    0  284M  193M sleep    0:00  0.00% oracle
>
> It is quite interesting.  After setting sga_target to 0, oracle database
> needs much fewer memory.  Do anyone help explain?
>
> Which one is better? 4G or 0?
>
> Thanks.
>
> --
> Johnson Chow

Best is reading the docs at the URL already provided.

Please note if you specify sga_target you will get a shared memory segment of that size. This is in the same link already posted.

--
Sybrand Bakker
Senior Oracle DBA