2 Replies Latest reply on May 16, 2019 1:49 AM by Beauty_and_dBest

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

    Beauty_and_dBest

      EBS R12.2.6

      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,