Oracle PL/SQL Tutorial/SQL PLUS Session Environment/statname

Combine v$statname and v$mystat

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