search cancel

Application Server crashing frequently with Massage ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

book

Article ID: 239923

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

The AutoSys application servers are crashing frequently with below Massage

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

autoflags -a 

1705 LINUX ORA 11.3.6 SP8CUM2 2f0a5e55 

 

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

What is the version of oracle?
 SELECT * FROM V$VERSION;
What are the limits set to for PGA_AGGREGATE_TARGET?
 show parameter pga;

Past cases with similar messages of 
"CAUAJM_E_18402 ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT"
were all closed documenting that the dba should be consulted and adjust or disable the limit.
And work with Oracle support if needed.

If they disagree, then the next step would be to provide Oracle AWR reports in 1 hour intervals
from the hours leading up to (when the issue is not happening) and including the problem timeframe (when the issue occurred).  
We can then ask our sustaining eng team to review to confirm there is anything additional to consider.