-- check the block running sql
select sid,serial#,sql_id,blocking_session,username from v$session where blocking_session>0;
-- find the current running sql
SELECT OSUSER,SERIAL#,SQL_TEXT,blocking_session
FROM V$SESSION, V$SQL
WHERE
V$SESSION.SQL_ADDRESS=V$SQL.ADDRESS