Hi,
One of our customers reported failure of couple of jobs, when i checked in alert log there is an errorORA-04036 - PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT and couple of sessions terminated.
Increasing PGA limit is not helping much. Please help to fix.