select o.sid, osuser, machine, count(*) num_curs,SQL_TEXT from v$open_cursor o, v$session s where user_name = 'AISINO' and o.sid=s.sid group by o.sid, osuser, machine ,SQL_TEXT order by num_curs desc;
select q.sql_text from v$open_cursor o, v$sql q where q.hash_value=o.hash_value and o.sid = 13 group by q.sql_text;