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?