应用某个批量无法正常进行，通过报错排查是由于在12c中参数pga_aggregate_limit参数的限制导致，此参数限制为硬性限制。此参数的修改非常简单，修改之后立即生效，需要注意的是此处CDB、PDB的pga_aggregate_limit参数都做了限制，调整的时候都做了调整。

[dayu1:oracle]:/oracle/app/oracle/diag/rdbms/cluacdb/CLUACDB1/trace>sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Sun Oct 21 01:09:40 2018Copyright (c) 1982, 2017, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionCDB$ROOT@CLUACDB> show parameter pgaNAME TYPE VALUE------------------------------------ ---------------------- ------------------------------pga_aggregate_limit big integer 9288Mpga_aggregate_target big integer 2GCDB$ROOT@CLUACDB> show parameter containerNAME TYPE VALUE------------------------------------ ---------------------- ------------------------------containers_parallel_degree integer 65535CDB$ROOT@CLUACDB> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 BMMSPDB READ WRITE NOCDB$ROOT@CLUACDB> alter session set container=BMMSPDB;Session altered.CDB$ROOT@CLUACDB> show parameter pga;NAME TYPE VALUE------------------------------------ ---------------------- ------------------------------pga_aggregate_limit big integer 2Gpga_aggregate_target big integer 1GCDB$ROOT@CLUACDB> select ISSYS_MODIFIABLE from v$parameter where name=‘pga_aggregate_limit‘; ISSYS_MODIFIABLE------------------IMMEDIATECDB$ROOT@CLUACDB> select ISSYS_MODIFIABLE from v$parameter where name=‘pga_aggregate_target‘;ISSYS_MODIFIABLE------------------IMMEDIATEalter session set container=BMMSPDB;alter system set pga_aggregate_limit=0 scope=both;alter system set pga_aggregate_limit=5000M scope=both;