how to check oracle current running sql status?

-- check the block running sql

select sid,serial#,sql_id,blocking_session,username from v$sessionwhere 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