select a.last_call_et,
a.event,
a.sql_id,
a.sid,
a.serial#,
a.username,
a.sql_id,
a.osuser,
a.machine,
a.program
from v$session a,v$session_wait b
where a.sid=b.sid
and b.wait_class<>'Idle'
order by 1 desc
a.event,
a.sql_id,
a.sid,
a.serial#,
a.username,
a.sql_id,
a.osuser,
a.machine,
a.program
from v$session a,v$session_wait b
where a.sid=b.sid
and b.wait_class<>'Idle'
order by 1 desc