memory limit oracle,pga physmem limit – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 1...

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%即可