How to know sql_id stuck in Oracle Database

 SELECT s.sid, s.serial#, s.status, s.event, s.wait_time, s.seconds_in_wait, s.sql_id, t.sql_text FROM v$session s, v$sql t WHERE s.sql_id = '4pcw4w2vh2ns8' AND s.sql_id = t.sql_id;