Re: Sure-fire "kill"
From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 15 Jul 2003 12:31:49 -0700
Message-ID: <3F1456A4.8E664D8_at_exxesolutions.com>
Date: Tue, 15 Jul 2003 12:31:49 -0700
Message-ID: <3F1456A4.8E664D8_at_exxesolutions.com>
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)Received on Tue Jul 15 2003 - 21:31:49 CEST