Kill oracle session on Win2000

From: julien <jul.gerard_at_laposte.net>
Date: 16 Jul 2003 07:49:51 -0700
Message-ID: <f3cb06b.0307160649.2f5f95ca@posting.google.com>

My problem is

I tried to kill an oracle session whith the command :

ALTER SYSTEM KILL SESSION '32,46851' but the session is now on status Killed and is still in the list of sessions. Moreover this session not seems to be attached to a thread on the server. When I execute the following command :

SELECT spid, osuser, s.program, schemaname FROM v$process p, v$session s
WHERE p.addr = s.paddr
AND s.SID = 32

there are no rows returned and so I can't use the os command "orakill sid thread" to really kill the session.

Is an other way to kill this session???

Thx for answers

julien. Received on Wed Jul 16 2003 - 09:49:51 CDT