Troubleshooting ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

  • 2023/05/26
  • ORACLE 9i-23ai
  • 836 views
  • Troubleshooting ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT已关闭评论

最近有家银行客户一套核心凌晨跑批时报出了ORA-04036,与12c后增加的PGA_AGGREGATE_LIMIT有关，环境oracle RAC 12.1.0.2 on AIX， 临时增加了PGA_AGGREGATE_LIMIT参数大小解决，事后找我分析原因
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

, ,

阅读全文