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 /