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 inst format 9
column lcet format 9999

set ver off
@header_dbinfo_sin_par

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