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

Last updated on DECEMBER 06, 2016

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.
***Checked for relevance on 20-Sep-2016***

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

 

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