Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: killing a 'killed' session
where sid is the sid of a session you're trying to kill (from
v$session).
On Thu, 20 Mar 2003 22:36:23 GMT, "Tom" <tomNOSPAM_at_teameazyriders.com> wrote:
>
>"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
>
>?
>
>
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Received on Thu Mar 20 2003 - 16:42:50 CST