High Usage Of PGA in 10.2.0.2 or below: Memory Allocation "Alloc environm" (Doc ID 842808.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later   [Release: 10.2 and later ]

Symptoms

On 10.2.0.2 or below:
There appears to be a high level of PGA/UGA usage
To further diagnose the issue, you have performed a Heap Dump, as per note
<<Note 233869.1>> Diagnosing and Resolving ORA-4030 errors
and have found that the Memory Allocation "Alloc environm" was excessive (where this additional diagnosis may have been performed by Oracle Support).

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms