Re: Sure-fire "kill"
From: Syltrem <syltremzulu_at_videotron.ca>
Date: Tue, 15 Jul 2003 16:27:02 -0400
Message-ID: <rsZQa.1911$Gf3.7262_at_tor-nn1.netcom.ca>
Date: Tue, 15 Jul 2003 16:27:02 -0400
Message-ID: <rsZQa.1911$Gf3.7262_at_tor-nn1.netcom.ca>
[Quoted] 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...Received on Tue Jul 15 2003 - 22:27:02 CEST
> 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?