ORA-00700: soft internal error

昨晚的问题，虚拟机内存从32G调整到80G，我调整了sga+pga=60G时重启告警，也没到内存的80%，如下

2023-04-19T17:24:46.358167+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_23724.trc  (incident=320169):
ORA-00700: soft internal error, arguments: [pga physmem limit], [16106127360], [13721879347], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_320169/orcl_ora_23724_i320169.trc
LICENSE_MAX_SESSION = 0

查看了support，参考文档 Getting ORA-00700 Message when Starting the Database (Doc ID 2610312.1)

 调小了pga，再次重启不再报错，改天好好研究下

官网建议

For example, the following settings can be used to startup the instance:

PGA_AGGREGATE_TARGET = 25% of 85% total memory
PGA_AGGREGATE_LIMIT = 50% of 85% total memory
SGA_TARGET = 50% of 85% total memory

-OR-

PGA_AGGREGATE_TARGET = 33% of 85% total memory
PGA_AGGREGATE_LIMIT = 67% of 85% total memory
SGA_TARGET = 33% of 85% total memory