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

2024-08-24T15:06:01.564447+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_91352.trc  (incident=156329):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:04.609067+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_91431.trc  (incident=156583):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:08.884772+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_91236.trc  (incident=156113):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:13.762382+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_91398.trc  (incident=156417):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:17.793524+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_67518.trc  (incident=155468):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:20.023709+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_67535.trc  (incident=156184):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:23.096491+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_77885.trc  (incident=156266):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:26.129378+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_71077.trc  (incident=156257):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:32.349868+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_91405.trc  (incident=156457):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:38.707953+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_91415.trc  (incident=156577):
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
2024-08-24T15:06:53.910740+08:00
Errors in file /u01/app/oracle/diag/rdbms/zhfwdb/zhfwdb/trace/zhfwdb_ora_67527.trc  (incident=155937):
处理办法：

alter system set pga_aggregate_limit=0 scope=both;