My Oracle Support Banner

High Session UGA & PGA Memory Reported in AWR (Doc ID 1483177.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

 

High Session UGA and PGA memory reported in AWR report, at the same time, database is running fine and no PGA or UGA memeory leak and all memory utilization is normal for all sessions.

 

Statistic                            Begin Value                           End Value
-------------------------------- ---------------                       ---------------
session pga memory                38,028,393,888              38,038,316,448
session pga memory max            49,088,550,880           49,096,310,752
session uga memory                34,045,055,032               34,054,831,024
session uga memory max           3.375988878E+11         3.378699940E+11

 

Changes

 

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