See which queries are currently executing in Oracle (11g).

select s.username, s.sid, s.osuser, sql_text 
from v$sqltext_with_newlines t,v$session s 
where t.address = s.sql_address 
and t.hash_value = s.sql_hash_value 
and s.status = 'ACTIVE' 
and s.username <> 'SYSTEM' 
order by s.sid, t.piece