Identifying High CPU Users

Listing . Identifying High CPU Users

SELECT n.username,  s.sid,  s.value  FROM v$sesstat s, v$statname t, v$session n

WHERE s.statistic# = t.statistic#
AND n.sid = s.sid
AND t.name='CPU used by this session'
ORDER BY s.value desc;