I am running on Oracle 12.1.0.2
We are currently getting 4030 (timobj call) which I have tracked to an
aggregate function which is instantiating lots of (untunable) pga memory.
Our pga_aggregate_target is 700GB and
our pga_aggregate_limit is 900G
We are not coming close to using our aggregate memory, yet the process is
erroring out at 32GB. I am trying to see if this is an Oracle limit (in the
past versions, this kind of untunable allocation would continue to rise) or
a linux one.
I have checked both ulimit -a and ulimit -Hm with both being unlimited.
Could there be another place that Linux is limiting the process? Has the
Oracle PGA allocation changed in 12c?
Thanks.
Henry