Statistics pro session

select   ses.SID,
nvl(ses.USERNAME,'ORACLE PROC') username,
sn.NAME statistic,
from   v$session ses,
v$statname sn,
v$mystat sest
where   ses.SID = sest.SID
and   sn.STATISTIC# = sest.STATISTIC#
and   sest.VALUE is not null
and   sest.VALUE != 0
order   by ses.USERNAME, ses.SID, sn.NAME


Leave a Reply

Your email address will not be published. Required fields are marked *