V$Sesstat Value "session Pga Memory (max)" Seems to be Limited to 4Gb
(Doc ID 1962594.1)
Last updated on FEBRUARY 22, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199. to 188.8.131.52 [Release 11.2 to 12.1]
Information in this document applies to any platform.
V$Sesstat is used to monitor the size of the PGA, using the column 'session pga memory max'. This is observed to increase to a maximum of 4Gb.
However PGA_AGGREGATE_TARGET is set to 200Gb and, using pmap, processes are seen to be exceeding 4Gb at OS level.
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