Enormous PGA utilization without SQL_TEXT
Hello,
I am experiencing weird behavior. The PGA is usually utilized around 40GB but now it is around 300GB. The SQL is never withing SQL area - nowhere to be found. Based on AWR report the top event is as below. The DB version is 19.20 running on rhel 7.
EventEvent ClassSession Type% ActivityAvg Active Sessions
acknowledge over PGA limitSchedulerFOREGROUND46.405.31CPU + Wait for CPUCPUFOREGROUND41.434.74