Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center