oracle技術(shù)分享 19c數(shù)據(jù)庫PGA設置過高出現(xiàn)告警
19c數(shù)據(jù)庫啟動后，發(fā)現(xiàn)alert日志里面出現(xiàn)告警：
2021-04-26T09:14:24.671750+08:00
**********************************************************************
PGA_AGGREGATE_TARGET specified is high
Errors in file
/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_13774.trc (incident=144013):
ORA-00700: soft internal error, arguments: [pga physmem limit], [14574157824], [8228128153], [], [], [], [], [], [], [], [], []
Incident details in:
/u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_144013/orcl1_ora_13774_i144013.trc
根據(jù)提示，PGA設置過高，如果SGA+PGA>OS Memory * 80%,啟動時則會給出錯誤警告（僅在19c版本中給出錯誤告警）
處理方法顯而易見了，將PGA調(diào)小，使得SGA+PGA<OS Memory * 80%即可
標簽：
