12c
OL6
Hi ALL,
We encountered error when running our reports concurrent program.
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
FROM ==> pa_task_assignments_v pta
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
FROM ==> pa_task_assignments_v pta
Our PGA_AGGREGATE_LIMIT was initially set to 0.
When we set it to 5G, previous error was resolved, but other reports encountered same issue.
How much bigger can I set our PGA_AGGREGATE_LIMIT? Or what is the biggest value I can set it to in relation to SGA?
Our server physical RAM is 60Gb.
Please help....
Kind regards,