Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Session Killed...!!

Re: Session Killed...!!

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Thu, 15 Sep 2005 11:08:15 -0400
Message-ID: <1a36296005091508081cb7ba21@mail.gmail.com>


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_at_gmail.com> 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_at_budco.com>:
> >
> > 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]On
> > Behalf Of Mercadante, Thomas F (LABOR)
> > Sent: Thursday, September 15, 2005 10:47 AM
> > To: chiragdba_at_gmail.com; 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]
> > On Behalf Of Chirag DBA
> > Sent: Thursday, September 15, 2005 10:36 AM
> > To: askdba_at_freelists.org; 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/
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 15 2005 - 10:10:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US