ORA-00700: soft internal error, arguments: [pga physmem limit]

联系:手机/微信(+86 13429648788) QQ(107644445)QQ咨询惜分飞

标题: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%即可
20200101023312