set pages 500
set linesize 750
column box format a30
column spid format a10
column username format a30 
column program format a30
column os_user format a20   
select b.sid,b.serial#,a.spid, substr(b.machine,1,30) box,b.logon_time logon_date , to_char (b.logon_time, 'hh24:mi:ss') logon_time,
 substr(b.username,1,30) username, substr(b.osuser,1,20) os_user, substr(b.program,1,30) program,status,b.last_call_et AS last_call_et_secs,b.sql_id 
 from v$session b,v$process a
 where  b.paddr = a.addr
 and type='USER' 
 order by b.sid;