SELECT osuser, username, sql_text from v$session a, v$sqltext b
where a.sql_address =b.address order by address, piece;
select s.USERNAME, sq.SQL_TEXT, s.LAST_CALL_ET
from v$open_cursor oc, v$sql sq, v$session s
where oc.HASH_VALUE = sq.HASH_VALUE
and s.SID = oc.SID
and s.STATUS = 'ACTIVE';