Re: Sure-fire "kill"

Fred wrote:

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

Whether it exists I don't know and don't care. What I do know is that kills are always immediate. Anything that shortens the process is not cleaning up after itself in temp, rollback, and/or undo and should be avoided unless you like making messes.

If you want to use heavy artillary ... just use kill -9.

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