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 swhere oc.HASH_VALUE = sq.HASH_VALUE   and s.SID = oc.SID   and s.STATUS = 'ACTIVE';