set linesize 125
set pagesize 109
column spid format a6
column sid format 999
column serial# format 99999
column machine format a25
column username format a14
column logon_time format a19
column type format a6
column program format a28
select p.spid, s.sid,s.serial#,s.machine,s.username,
to_char(s.logon_time, 'DD-MON-YY HH:MI:SS') logon_time, s.type, s.status, s.program
from v$process p, v$session s
where s.paddr=p.addr and s.type = 'USER' and s.username <> 'SYS' and s.username <> 'SYSTEM'
order by s.logon_time desc;