Could not kill a session in V$SESSION
Problem Description :
Alter system kill session
Resolution :
The alter system kill session command did not kill the job in v$session. I tried running it with alter system kill session '30,521'immediate but that did not work either. The status changed to killed but would not go away. I then got the process id number off of the v$sessions table and killed the process in unix using the kill -9 F##### command. this allowed for the process to disapear in v$sessions
Revision Date : 1/24/2007
Keywords : reserve