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>