Re: SGA limit on Solaris x86

From: Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK>
Date: 7 Oct 2008 11:27:27 GMT
Message-ID: <gcfh2v$koi$1@net44p.hkbu.edu.hk>


Mr. Chow Wing Siu <wschow_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
Received on Tue Oct 07 2008 - 06:27:27 CDT

Original text of this message