column sid_serial format a10
column username format a20
column STATUS format a10
column event format a30
column OSUSER format a10
column machine format a30
column program format a20
column inst format 9

select inst_id inst,sid||','||serial# sid_serial,username,status,last_call_et,sql_id,event,to_char(logon_time,'ddmmyyyy hh24:mi:ss') LOGON_TIME,program
from gv$session
where username like upper('%&1%') and event not like 'Streams%'
and status='ACTIVE'
order by inst_id,last_call_et;
