Session Info from given SID

----------------------------------
-Session Info from SID
-File Name: sid.sql
-Usage : @sid
-----------------------------------

set line 200
col program for a16
col MODULE for a16
col action for a30
col 'Time Hrs' for 999999.99
col user@machine  for a30
col (SID,SERIAL#)  for a13
set line 200
col SPID for a10

select b.spid,a.sid||','||a.serial# "(SID,SERIAL#)",a.status,a.last_call_et/3600 "Time Hrs",a.username||'@'||a.machine as "user@machine",a.program,a.module,a.action,a.type 
from gv$session a,gv$process b where a.sid=&SID and a.paddr=b.addr
/