Check Running SQL in Oracle Database

 SET LINESIZE 2000

SET HEADING OFF SELECT s.sid, s.serial#, s.status, s.username, s.osuser, s.machine, s.program, s.module, s.action, s.client_info, s.event, s.last_call_et, t.sql_text FROM v$session s, v$sqltext t WHERE s.sid in (84,988) AND s.sql_address = t.address AND s.sql_hash_value = t.hash_value ORDER BY t.piece;