Check Oracle Open Cursors by Session

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)