My Oracle Support Banner

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 11.2.0.0. to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Goal

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.

Solution

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