from v$session s, v$process p
where s.username = 'CHRS'
and p.addr (+) = s.paddr; 2 3 4
SID SERIAL# STATUS SPID
---------- ---------- -------- ------------------------
139 17563 INACTIVE 21630
142 56779 ACTIVE 10920
148 20995 INACTIVE 27150
SQL> alter system kill session '142,56779';
System altered.
No comments:
Post a Comment