Sessions - Display session_wait events and associated user and sql 
set echo off
--
--  Name: sessions_wait.sql
--
--  Parms: none
--
--  Description: Sessions - Display session_wait events and associated user and sql
--
--  Compatability: 7.3.4 and above
--
--  Usage: @sessions_wait 
--
define lsize=133
set linesize &&lsize
set pages 50
--
select 	event, username,osuser, sw.sid, seq#, seconds_in_wait, wait_time, sa.sql_text,sa.address
from 	V$SESSION_WAIT sw, V$SESSION s, v$sqlarea sa
where 	sw.SID = s.SID 
and 	NOT(event like 'SQL%') 
and 	NOT(event like '%message%') 
and 	NOT(event like '%timer%') 
and 	NOT(event like '%pipe get%') 
and   not(event like 'slave wait')
and   s.sql_address = sa.address
order by event,wait_time desc;