Re: killing a 'killed' session

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Thu, 20 Mar 2003 23:25:04 GMT
Message-ID: <k5sea.1427$8T5.11835448@news-text.cableinet.net>

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:3e7a439a.2094599024_at_nyc.news.speakeasy.net...
> where sid is the sid of a session you're trying to kill (from
> v$session).
>

SID SERIAL# USERNAME ROUND(LAST_CALL_ET/60)*60 IDLE

---------- ---------- -------------------- ------------------------- -------
-
        13      11567 XXXXXXX                                1057440 KILLED

select p.spid
  2 from v$process p, v$session s
where s.paddr = p.addr
  3 4 and s.sid = &1
  5 ;
Enter value for 1: 13
old 4: and s.sid = &1
new 4: and s.sid = 13

no rows selected

? Received on Thu Mar 20 2003 - 17:25:04 CST