ora-04036 with huge PL/SQL allocated memory in dbms_scheduler

Hello everyone.

We run Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production, dedicated server mode on Linux x86_64. One of our dbms_scheduler jobs (PL/SQL code) fails with:

ORA-12012: error on auto execute of job "DATA"."CLASS_RECALC_JOB"ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMITORA-06512: at "API.PROCESSES_PKG", line 522ORA-06512: at "API.PROCESSES_PKG", line 267...PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT of 2048 MB

The related parameters are:

pga_aggregate_limit = 2848Mpga_aggregate_target = 0

From the trace file, just before the process/session being killed:

Summary of subheaps at depth 21801 MB total:  1801 MB commented, 122 KB permanent    96 KB free (20 KB in empty extents),    1436 MB, 92231 chunks:  "pl/sql vc2                "     362 MB, 23253 chunks:  "pmucalm coll              "