Descobir que sessão está usar mais CPU

SQL>
select p.spid OsPID_Unix, ss.sid, se.serial#, se.command, ss.value CPU , se.username,se.program
from v$sesstat ss, v$session se, v$process p
where ss.statistic# in (select statistic# from v$statname where name = 'CPU used by this session')
and se.sid=ss.sid
and se.paddr= p.addr
and ss.sid > 6
order by ss.value, ss.sid;