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.