Re: Session Killed...!!

how to find the os process associated with it?
 so that you can do kill -9 @#@#.
 regards - Chirag
 On 9/15/05, Yongping Yao <yaoyongping@xxxxxxxxx> wrote: 
> 
> I agree that it's very strange to kill a session in Oracle. As I
> experienced, SELECTs are more easier to kill than DMLs and SELECTs
> running after a long time are more difficult to kill. UPDATE is the
> most difficult to kill. Oracle always reponds as "we have marked the
> session killed" but the session is still there and the lock remained
> hold. Anyone with good recommendations?
> 
> 2005/9/15, Chen, Sarah <Sarah_Chen@xxxxxxxxx>:
> >
> > 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.
> >
> > Sarah
> >
> >
> > -----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
> > activity.
> >
> >
> >
> >
> >
> > 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 9.0.1.3 <http://9.0.1.3> on solaris.
> >
> >
> >
> >
> >
> > any idea? We already hit the bug ora-07442.
> >
> >
> >
> >
> >
> > regards - chirag
> 
> 
> --
> Yao Yongping
> Learning Oracle, UNIX/Linux...
> Love Reading, Classical Music, Philosophy, Economics etc.
> Blog: http://blog.csdn.net/ern
> http://spaces.msn.com/members/yaoyp/
>

Other related posts: