select sid,
       s.username, s.terminal, s.process, s.osuser,
       a.sql_text
from   sys.v_$session s, sys.v_$sqlarea a
where  s.type           = 'USER'
and    s.sql_address    = a.address
and    s.sql_hash_value = a.hash_value
/