本帖最后由 zhouxianwang 于 2012-6-20 14:28 编辑
我一台网站的ORACLE,以前是12G内存,昨天加到32G内存,加完之后:Execute to Parse 更低了
没加之前还是4.5 左右,这是什么问题?
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 16G
sga_target big integer 16G
SQL> show parmeter pga;
SP2-0158: unknown SHOW option "parmeter"
SP2-0158: unknown SHOW option "pga"
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 16G
sga_target big integer 16G
SQL> show parameter pga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 3G
SQL> show parameter db_cache;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_advice string ON
db_cache_size big integer 8G
SQL>
cc.JPG
(20.18 KB, 下载次数: 15)
2012-6-20 14:27 上传
bbb