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