Re: Sure-fire "kill"

Syltrem wrote:

> Possibly you are referring to a session where the Oracle side of things has
> ceased to exist, but where the client is still alive.
> In this case you need to do a kill -9, or CTRL-ALT-DEL to kill the client
> process.
>
> Session will remain in KILLED status until the client has disconnected from
> Oracle.
>
> --
>
> OpenVMS 7.3-1, Oracle 8.1.7.4
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
> To reply to me directly, remove zulu from my address
>
> "Fred" <noway_at_jose.com> a écrit dans le message de
> news:noway-0F6052.14454715072003_at_vienna7.his.com...
> > There is a setting in INIT.ORA that has the unintended side-effect of
> > making sure the ALTER SYSTEM KILL SESSION command has immediate affect.
> > Without this setting, I've seen some instances where the session reports
> > as being KILLED in V$SESSION but is not physically removed until the
> > instance is bounced. Does anyone remember this value offhand?

I think what the OP is referring to is the time between when a kill is issued and the session shows as killed in v_$session.

This time is the time Oracle uses to clean up the mess the session left behind.

And, as I said, if there is someway to avoid it I am not aware of it and would advise against using it.

--
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)