PGA_AGGREGATE_TARGET specified is high

因客户要求扩展内存，重启一个19c单机，发现标题报错，该虚拟机内存200G

[root@db ~]#  lsmem
RANGE                                  SIZE  STATE REMOVABLE BLOCK
0x0000000000000000-0x00000000bfffffff    3G online       yes   0-2
0x0000000100000000-0x000000323fffffff  197G online       yes 4-200

Memory block size:         1G
Total online memory:     200G
Total offline memory:      0B
[root@db ~]#

第一次内存分配sga+pga=120G+35G=155G

2024-05-21T11:22:31.763764+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_64393.trc  (incident=716809):
ORA-00700: soft internal error, arguments: [pga physmem limit], [37580963840], [30316014796], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_716809/orcl_ora_64393_i716809.trc

第二次内存分配sga+pga=100G+40G=140G

2024-05-21T11:32:23.292894+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_36382.trc  (incident=839690):
ORA-00700: soft internal error, arguments: [pga physmem limit], [42949672960], [41053433036], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_839690/orcl_ora_36382_i839690.trc

第3次内存分配sga+pga=105G+35G=140G
不再报错

因停机时间有限，没继续测试下去

参考文档：
ORA-700 [sms physmem limit] / [pga physmem limit] Errors while Starting the Database (Doc ID 2610312.1)
Limiting Process Size with Database Parameter PGA_AGGREGATE_LIMIT (Doc ID 1520324.1)
Automatic Memory Management (AMM) SGA and PGA Management in 11g and Above (Doc ID 1392549.1)

20240606更新-128G内存的机器测试

sga为80G，pga为20g，报错如下
2024-06-06T19:33:24.049543+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_3735.trc  (incident=150403):
ORA-00700: soft internal error, arguments: [pga physmem limit], [21474836480], [17584708812], [], [], [], [], [], [], [], [], []

sga为75G，pga为25g，报错如下
2024-06-06T19:13:03.961090+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_2027.trc  (incident=126402):
ORA-00700: soft internal error, arguments: [pga physmem limit], [26843545600], [20269063372], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/incident/incdir_126402/zhfwdb_ora_2027_i126402.trc

sga为70G，pga为25g，报错如下
2024-06-06T19:37:51.376537+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_4379.trc  (incident=174404):
ORA-00700: soft internal error, arguments: [pga physmem limit], [26843545600], [22953417932], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/incident/incdir_174404/zhfwdb_ora_4379_i174404.trc

sga为70G，pga为22g，报错如下
2024-06-06T19:40:15.998557+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_4960.trc  (incident=222406):
ORA-00700: soft internal error, arguments: [pga physmem limit], [23622320128], [22953417932], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/incident/incdir_222406/zhfwdb_ora_4960_i222406.trc