Who is waiting

My Scripts
========


select sw.sid,s.username,sw.event,sw.wait_time,to_char(s.logon_time,'dd-mon-yyyy::hh24:mi:ss') "log time",
       action
from V$session s, V$session_wait sw
where s.username is not null
and sw.sid =s.sid
and sw.event not like 'SQL%'
and sw.event not like 'pipe get'
and sw.event not like 'queue%'
and sw.event not like 'null%'
and sw.event not like 'PL%'
and sw.event not like 'PX%'
order by 3