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

set ver off

--alter session set nls_numeric_characters = ',.';

@header_dbinfo_sin_par

--SET TERMOUT    ON

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,machine,service_name
from gv$session
where inst_id = 1 
and username like upper('%&1%') and event not like 'Streams%'
and status='ACTIVE'
order by inst_id,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,machine,service_name
from gv$session
where inst_id = 2
and username like upper('%&1%') and event not like 'Streams%'
and status='ACTIVE'
order by inst_id,last_call_et desc;