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