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>
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 ChowReceived on Tue Oct 07 2008 - 06:27:27 CDT