修改PGA

1 查看当前PGA

su - oracle
ps -ef | grep pmon
export ORACLE_SID=实例名
sqlplus / as sysdba
show parameter pga

2 备份参数文件

create pfile='/tmp/woqu_date.ora' from spfile;

3 修改PGA（动态修改）

11g

alter system set pga_aggregate_target=xxxG scope=both sid='*';

12c以上

alter system set pga_aggregate_limit=xxxG scope=both sid='*'; 
alter system set pga_aggregate_target=xxxG scope=both sid='*';

备注1：pga_aggregate_limit必须在指定范围内
00093, 00000, “%s must be between %s and %s”
// *Cause: The parameter value is not in a valid range.
// *Action: Modify the parameter value to be within the specified range.

备注2：pga_aggregate_target 不能超过 pga_aggregate_limit 的 50%
00856, 00000, “PGA_AGGREGATE_TARGET cannot be set higher 50 percent of PGA_AGGREGATE_LIMIT.”
// *Cause: PGA_AGGREGATE_TARGET value was greater than 50 percent the current value of PGA_AGGREGATE_LIMIT.
// *Action: Increase PGA_AGGREGATE_LIMIT or use a lower PGA_AGGREGATE_TARGET.

PGA_AGGREGATE_LIMIT
PGA_AGGREGATE_TARGET

4 查看修改后PGA

show parameter pga