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 machine format a20
column service_name format a20
column inst format 9

set ver off
@header_dbinfo_sin_par

select inst_id inst,sid||' '||serial# sid_serial,username,status,last_call_et,sql_id,event,service_name
from gv$session
where username like upper('%&1%') and event not like 'Streams%'
order by status,last_call_et;