select SID,serial# ,username,osuser,machine,program,process,to_char(logon_time,‘yyyy-mm-dd hh24:mi:ss’) logon from v s e s s i o n w h e r e p a d d r i n ( s e l e c t a d d r f r o m v session where paddr in ( select addr from v sessionwherepaddrin(selectaddrfromvprocess where spid in(‘&pid’));
select s.sid, s.serial#, s.LOGON_TIME, s.machine, p.spid, p.terminal
from v
s
e
s
s
i
o
n
s
,
v
session s, v
sessions,vprocess p
where s.paddr = p.addr
and s.sid = 2;
ALTER system kill session ‘2,606’;