set lines 200 pages 50
column inst format 9999
column serial# format 9999999
column username format a15
column sid format 9999
column osuser format a19
column program format a33
column machine format a26
column name format a16
column logon format a15
column event format a30
select inst_id INST,
       sid,
       serial#,
       username,
       to_char(logon_time,'DD/MM-HH24:MI:SS') logon,
       last_call_et,
       osuser,
       program,
       status,
       machine, event, sql_id
from gv$session
where (program not like 'ORACLE.EXE%'
   or program is null)
--and status ='ACTIVE'
and username is not null
/*where program = 'sqlplus.exe'
   or program like '%ElinIoCore%'
   or program like '%CommSrv.exe%'*/
order by Status desc, last_call_et, username, logon_time;