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

@header_dbinfo_sin_par

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;