联系：手机/微信(+86 17813235971) QQ(107644445)
标题：ORA-00700: soft internal error, arguments: [pga physmem limit]
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
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%即可
