column sid_serial format a10
column username format a20
column ST format a2
column event format a30
column OSUSER format a10
column machine format a30
column program format a20
column inst format 9
column service_name format a13
column LOGON_TIME format a20

set ver off

@header_dbinfo_sin_par

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

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