Ok, So we just upgraded to 18c on an exadata x5. We keep getting the errors of "acknowledge over PGA limit". Yet when I check v$pgastat it keeps showing we aren't hitting the limit.
"maximum PGA allocated",7044533248,"bytes",0
SQL> sho parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 8G
pga_aggregate_target big integer 4G
What gives here?