RE: Session Killed...!!

Chirag,  

Use the following:  

select vp.pid,vs.sid,spid,vs.program

from v$process vp,v$session vs

where vs.paddr=vp.addr  

The spid column is the unix process id.  

So to kill a session, I issue a kill -9 the spid value, then issue a kill session within Oracle.

Tom  

From: Chirag DBA [mailto:chiragdba_at_gmail.com] Sent: Thursday, September 15, 2005 11:08 AM To: yaoyongping_at_gmail.com
Cc: Sarah_Chen_at_budco.com; Mercadante, Thomas F (LABOR); Oracle-L Freelists
Subject: 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_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 <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 <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 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://spaces.msn.com/members/yaoyp/> 

 


--
http://www.freelists.org/webpage/oracle-l