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

Home -> Community -> Usenet -> c.d.o.server -> Re: Sure-fire "kill"

Re: Sure-fire "kill"

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Jul 2003 06:14:06 -0700
Message-ID: <2687bb95.0307170514.1a1056c4@posting.google.com>


Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F160621.9F171420_at_exxesolutions.com>...
> Joel Garry wrote:
>
>
> I have yet to see kill -9 not kill a process.
>
> Looking at v_$session is not a reliable indication of whether a session has been killed.

Daniel, From experience I can confirm that there are circumstances where UNIX kill -9 commands will in fact fail. But that is a UNIX issue that is not caused by Oracle though I think the issue can affect Oracle. We have experienced the problem on both the Pyramid and Sequent platforms. But I believe it is secondary and think the information you posted will solve the problem most of the time.

Also from a logical point of view it would seem to me that v$session should be a reliable indicator of a session being killed. The status should reflect the current state of the session or the session entry should be removed. Logically for the view to reflect any other state would indicate a failure in Oracle's design logic or code.

Received on Thu Jul 17 2003 - 08:14:06 CDT

Original text of this message

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