High Session UGA & PGA Memory Reported in AWR
(Doc ID 1483177.1)
Last updated on FEBRUARY 02, 2022
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
-------------------------------- --------------- ---------------
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 |