select
/*
if sid not found in v$session then disconnected */
if sid not found in v$session then disconnected */
decode(nvl(to_char(s.sid),-1),-1,’DISCONNECTED’,’CONNECTED’)
“STATUS”,
topsession.session_id “SESSION_ID”,
u.name “NAME”,
topsession.program “PROGRAM”,
max(topsession.CPU) “CPU”,
max(topsession.WAITING) “WAITING”,
max(topsession.IO) “IO”,
max(topsession.TOTAL) “TOTAL”
from
( previous query ) topsession,
( previous query ) topsession,
v$session
s,
s,
user$
u
u
where
u.user#
=topsession.user_id and
=topsession.user_id and
/*
outer join to v$session because the session might be disconnected */
outer join to v$session because the session might be disconnected */
topsession.session_id = s.sid (+) and
topsession.session_serial#
= s.serial# (+)
= s.serial# (+)
group
by topsession.session_id, topsession.session_serial#,
topsession.user_id,
by topsession.session_id, topsession.session_serial#,
topsession.user_id,
topsession.program,
s.username,s.sid,s.paddr,u.name
s.username,s.sid,s.paddr,u.name
order
by max(topsession.TOTAL) desc;
by max(topsession.TOTAL) desc;
Recent Posts