注:
1)pga_aggregate_target以下简称PAT
2)我的环境:
11:42:10 sys@ORCL (^ω^) select * from v$version where rownum=1;
BANNER
----------------------------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
两个参数:
11:40:31 sys@ORCL (^ω^) show parameter workarea_size_policy
NAME_COL_PLUS_S TYPE VALUE_COL_
--------------- ---------- ----------
workarea_size_p string AUTO
olicy
11:40:55 sys@ORCL (^ω^) show parameter pga_aggregate_target
NAME_COL_PLUS_S TYPE VALUE_COL_
--------------- ---------- ----------
pga_aggregate_t big intege 194M
arget r
workarea_size_policy设置为auto,pga_aggregate