Check Oracle Open Cursors by Session
Jump to navigation
Jump to search
select o.sid, o.sql_text, o.address, o.hash_value, o.user_name, s.schemaname, o.sql_id from v$open_cursor o, v$session s where o.saddr = s.saddr and o.sid = s.sid and ( O.SID = &SID)