Combine v$statname and v$mystat : statname « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. statname
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








29.57.statname
29.57.1.Combine v$statname and v$mystat