v$session
SQL > SELECT * FROM V$SESSION WHERE audsid = userenv('sessionid');
Using v$session you can
list all sessions
identify active sessions with STATUS=’ACTIVE’ and how long it was running LAST_CALL_ET
see running sql with SQL_ID or SQL_ADDR
If session is waiting check WAIT columns for current wait details.