Sessions Currently on Database

----------------------------------
-Sessions Currently Running
-File Name : sess.sql
-Usage : @sess
-----------------------------------

set line 200
col program for a20
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 150

select sid||','||serial# "(SID,SERIAL#)",status,last_call_et/3600 "Time Hrs",username||'@'||machine as "user@machine",program,module,action,type 
from gv$session
/