kill session and orakill
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.
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..
How do i identify the os process of the session?
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..
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?
Click Here to Expand Forum to Full Width