Re: Sure-fire "kill"

Joel Garry wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F160621.9F171420_at_exxesolutions.com>...
> >
> > I have yet to see kill -9 not kill a process.
>
> I have. That is what a zombie is. But I wasn't talking about that.
>
> >
> > Looking at v_$session is not a reliable indication of whether a session has been killed.
>
> Fair enough. What would be a reliable indication of whether a session
> has been killed? Are you saying Oracle doesn't know?
>
> jg
> --
> @home.com is bogus.
> http://groups.google.com/groups?q=zombie+author:Joel+author:Garry&hl=en&lr=&ie=UTF-8&newwindow=1&selm=1995Jul5.162913.20702%40rossinc.com&rnum=5

And attempt to do anything new with the session after the kill should indicate, immediately, that the session has been killed. The fact that information related to the session remains in the v_$ views does not.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)