delete

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