To find the current SQL statement being executed by particular session in Oracle, Query V$SQLAREA and V$SESSION views.
Here is the query to report the current SQL statement being executed by a session:
select substr(v2.sid,1,5) "SID"
,substr(v2.username,1,8) "Username"
,substr(program,1,10) "Program"
,sql_text
from
sys.v_$sqlarea v1,
sys.v_$session v2
where
v1.address= v2.sql_address and
v1.hash_value = v2.sql_hash_value;
The above query will return the following for example:
SID Username Program SQL_TEXT --- -------- ------- ----------------------------------- 12 SCOTT sqlplus insert into ken values(1000)