Check system stats for the session

by Granville Bonyata on June 2, 2017

I always have to look this query up, so am posting it here to save time.


SELECT s.name,m.value
FROM v$sysstat s,
     v$mystat m
WHERE s.STATISTIC#=m.STATISTIC#
ORDER BY m.value DESC, s.name
/

Previous post:

Next post: