应用某个批量无法正常进行,通过报错排查是由于在12c中参数pga_aggregate_limit参数的限制导致,此参数限制为硬性限制。此参数的修改非常简单,修改之后立即生效,需要注意的是此处CDB、PDB的pga_aggregate_limit参数都做了限制,调整的时候都做了调整。
[dayu1:oracle]:/oracle/app/oracle/diag/rdbms/cluacdb/CLUACDB1/trace>sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Oct 21 01:09:40 2018
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
CDB$ROOT@CLUACDB> show parameter pga
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
pga_aggregate_limit big integer 9288M
pga_aggregate_target big integer 2G
CDB$ROOT@CLUACDB> show parameter container
NAME TYPE VALUE
------------------------------------ ---------------------- ---------------