Oracle PL/SQL Tutorial/SQL PLUS Session Environment/statname
Combine v$statname and v$mystat
<source lang="sql">
SQL> SQL> SQL> select a.name, b.value
2 from v$statname a, v$mystat b 3 where a.statistic# = b.statistic# 4 and lower(a.name) like "%pga%" 5 /
NAME VALUE
----------
session pga memory 2464720 session pga memory max 2743892</source>