Oracle: Show your active session

Here's a query to show your sessions and which is active.

select 
 case when audsid = sys_context('userenv','sessionid') then 'X' end me 
 ,v.sid
 ,v.serial#
 ,v.audsid
 ,v.username
 ,v.status
 ,v.osuser
 ,v.machine
 ,v.program
 ,v.*
from v$session v
where v.username = 'YOUR_ORACLE_USERNAME'
;