Opened cursors for all users


select  nvl(USERNAME,'ORACLE PROC')||'('||s.SID||')' username,
SQL_TEXT
from   v$open_cursor oc,
v$session s
where   s.SADDR = oc.SADDR
order   by 1


select  nvl(USERNAME,'ORACLE PROC')||'('||s.SID||')' username,
SQL_TEXT
from   v$open_cursor oc, v$session s
where   s.SQL_ADDRESS = oc.ADDRESS
and   s.SQL_HASH_VALUE = oc.HASH_VALUE
order   by 1

 

Leave a Reply

Your email address will not be published. Required fields are marked *