Details regarding sessions which are causing high waits and cpu

select  nvl(ss.USERNAME,'ORACLE PROC') username,
ss.SID, ss.serial#,ss.sql_hash_value,sa.executions,VALUE cpu_usage from    v$session ss,
v$sesstat se, v$sqlarea sa, v$statname sn where   se.STATISTIC# = sn.STATISTIC#
and     NAME like '%CPU used by this session%'
and     se.SID = ss.SID
and     ss.sql_hash_value = sa.hash_value
and     value > 0
order   by VALUE desc;