SCRIPT:To check Session status associated with the specified os process id

select a.username,a.sid , a.serial#,
p.spid ,last_call_et,status
from V$SESSION a, V$PROCESS p
where a.PADDR = p.ADDR
and p.spid='&pid'