Мониторинг

select sw.SID,sw.EVENT,ss.USERNAME,ss.SCHEMANAME,ss.MACHINE,ss.OSUSER,ss.SQL_ADDRESS
from
v$session_wait sw
left join
v$session ss
on sw.SID=ss.SID
left join
v$sql s
ON s.ADDRESS=ss.SQL_ADDRESS
where sw.EVENT not in ('SQL*Net message from client',
                       'Streams AQ: waiting for messages in the queue',
                       'wait for unread message on broadcast channel',
                       'PL/SQL lock timer')
   AND ss.USERNAME IS NOT NULL
order by sw.EVENT



/* ---------------------------------------------------


   select *
   from
   v$sql s
   where s.ADDRESS='xxxxxxxxx'


--------------------------------------------------- */