My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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
<> 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.