RE: Session Killed...!!

  • From: "Chen, Sarah" <Sarah_Chen@xxxxxxxxx>
  • To: "'Thomas.Mercadante@xxxxxxxxxxxxxxxxx'" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, "'chiragdba@xxxxxxxxx'" <chiragdba@xxxxxxxxx>, "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 Sep 2005 10:54:01 -0400

I always check process id as well as sid and serial# while killing a session
from Oracle.
I will always query v$session before and after, and if the status of
v$session marked "killed", and then I will go ahead kill OS process to clean
this session. It always works on Solaris.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Mercadante, Thomas F (LABOR)
Sent: Thursday, September 15, 2005 10:47 AM
To: chiragdba@xxxxxxxxx; Oracle-L Freelists
Subject: RE: Session Killed...!!

If you kill the unix process associated with this session first, and then
the session it will go away.


Killing sessions in Oracle has always been weird.  Sometimes they go away
and sometimes not, depending on OS.  In Windows, use orakill to kill the
session - this always seems to work in windows.  And killing the unix
session then the Oracle session seems to work just fine in AIX.



From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Chirag DBA
Sent: Thursday, September 15, 2005 10:36 AM
To: askdba@xxxxxxxxxxxxx; Oracle-L Freelists
Subject: Session Killed...!!


Hi ,


I saw many users on my database connected for more than 6 days without any


I killed 1 user and still the status in v$session is showing as killed.


but it it not getting removed from the v$session.


I am running <>  on solaris.


any idea? We already hit the bug ora-07442.


regards - chirag

Other related posts: