19c数据库启动有ORA-00700警告
2019-12-31T20:29:10.905779+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_25403.trc (incident=122887):
ORA-00700: soft internal error, arguments: [pga physmem limit], [3332374528],[2112652492], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_122887/orcl_ora_25403_i122887.trc
分析trace文件
WARNING: PGA_AGGREGATE_TARGET (3178 MB) is too high for
the amount of physical memory (31783 MB) and
SGA size (24576 MB) - it should be less than 2014 MB.
提示PGA_AGGREGATE_TARGET 设置过大.官方对于此问题有说明,分配给数据库的内存(sga+pga)小于80%即可