Search notes:

Oracle: V$MYSTAT

v$mystat records statistical data about the session that accesses it. Join statistic# with v$statname
select 
  nam.name,
  mys.value
from
  v$mystat   mys   join
  v$statname nam on mys.statistic# = nam.statistic#
order by
  nam.name;
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/mystat/show.sql

See also

Interesting session statistics
v$sesstat
Oracle Dynamic Performance Views
http://www.adp-gmbh.ch/ora/tuning/statistics.html

Index