kill session and orakill

[steeve123]

I want to kill a session.
I kill the session using alter system kill session.
The session is marked for kill.
It still consume ressources. Still lock other session.
I use orakill my_instance the_spid.


The session still remains. Is there another nuke out there to kill a session?
I cant shutdown the database each time i have this problem.

Im on 10.2.0 on windows 32 bits.

[davey23uk]

kill the os process

[abhaysk]

you cant kill that on windows like u do on unix.. as there is only one process for windows that is oracle.exe.. and session in oracle are threads..

[steeve123]

How do i identify the os process of the session?

[abhaysk]

steeve.. i think there is some utility to end any thread of any process.. but u need to map that thread id to pid of oracle..

[steeve123]

I used the task manager to identify the process and it is not in there.

I used this query to identify my spid for orakill and pid to kill the thread:
select s.sid, s.PROGRAM, p.spid , s.osuser, p.pid
from v$process p, v$session s
where p.addr = s.paddr
and s.sid = 248;


If i do orakill ORCL 5508
Its says it kill it , by it is still in oracle and still locking other session.

I did pskill 39
Did not find the process.

Does anybody has a link or documentation to foward me too?


How can i identify the thread and kill it?