Memory

Monitoring PGA Usage by Username in Oracle Database Purpose V$SESSTAT is the view that holds one statistic value per session, and two of its statistics describe how much Program Global Area (PGA) memory a session uses right now and the most it has used. The script below joins V$SESSTAT to V$STATNAME, filters the …