因客户要求扩展内存,重启一个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