Re: killing a 'killed' session

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:3e7a3e35.2093217958_at_nyc.news.speakeasy.net...
> select p.spid
> from v$process p, v$session s
> where s.paddr = p.addr
> and s.sid = &1
>
> kill -9 what it returns
> (if not mts, with mts u'd have to kill that server i think)
> u can also try sqlnet.ora parameter SQLNET.EXPIRE_TIME
> alter system kill session sucks.
>

select p.spid
from v$process p, v$session s
where s.paddr = p.addr
and s.sid = &1

Enter value for 1: 11567
old 4: and s.sid = &1
new 4: and s.sid = 11567

no rows selected

? Received on Thu Mar 20 2003 - 16:36:23 CST