set linesize 333
set pagesize 1000
col event for a30
col sess for a18
col username for a10
col program for a40
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select ss.inst_id||':'||ss.sid||':'||ss.username sess,ss.event,ss.program,ss.p1,ss.p1raw,ss.sql_id, trunc(ss.last_call_et/60) lastcall--,ss.logon_time
from gv$sesstat st, gv$session ss
where st.STATISTIC#=18 and st.sid = ss.sid
and ss.username not in ('SYS','SYSTEM','GOLDENGATE')
and ss.status = 'ACTIVE'
and st.value <>0 and username is not null
--and ss.WAIT_CLASS<>'Idle'
and trunc(ss.last_call_et/60) > 5
order by ss.inst_id,ss.last_call_et desc,st.VALUE desc;
set pagesize 1000
col event for a30
col sess for a18
col username for a10
col program for a40
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select ss.inst_id||':'||ss.sid||':'||ss.username sess,ss.event,ss.program,ss.p1,ss.p1raw,ss.sql_id, trunc(ss.last_call_et/60) lastcall--,ss.logon_time
from gv$sesstat st, gv$session ss
where st.STATISTIC#=18 and st.sid = ss.sid
and ss.username not in ('SYS','SYSTEM','GOLDENGATE')
and ss.status = 'ACTIVE'
and st.value <>0 and username is not null
--and ss.WAIT_CLASS<>'Idle'
and trunc(ss.last_call_et/60) > 5
order by ss.inst_id,ss.last_call_et desc,st.VALUE desc;