select decode(sum(decode(s.serial#,l.serial#,1,0)),0,'No','Yes') " ", s.sid "Session ID",s.status
"Status", s.username "Username", RTRIM(s.osuser) "OS User",b.spid "OS Process ID",s.machine
"Machine Name", s.program "Program" from v$session s, v$session_longops l,v$process b where (s.sid
= l.sid(+)) and s.paddr=b.addr group by s.sid,s.status,s.username,s.osuser,s.machine,s.program,
b.spid, b.pid order by s.sid ;
"Status", s.username "Username", RTRIM(s.osuser) "OS User",b.spid "OS Process ID",s.machine
"Machine Name", s.program "Program" from v$session s, v$session_longops l,v$process b where (s.sid
= l.sid(+)) and s.paddr=b.addr group by s.sid,s.status,s.username,s.osuser,s.machine,s.program,
b.spid, b.pid order by s.sid ;
select decode(sum(decode(s.serial#,l.serial#,1,0)),0,'No','Yes') " ",
s.sid "Session ID",--@@SPID?
s.status "Status",
s.username "Username",--loginame ?
RTRIM(s.osuser) "OS User",
b.spid "OS Process ID",--db_name(dbid)?
s.machine "Machine Name",--hostname?
s.program "Program"
from v$session s, v$session_longops l,v$process b
where (s.sid = l.sid(+)) and s.paddr=b.addr
group by s.sid,s.status,s.username,s.osuser,s.machine,s.program,b.spid, b.pid
order by s.sid ;