当然是“杀死” [英] Sure-fire "kill"

问题描述

INIT.ORA中有一个设置，它具有

的意外副作用，确保ALTER SYSTEM KILL SESSION命令立即生效。

没有此设置，我已经看到一些会话报告

在V $ SESSION中被杀死但在

实例被退回之前没有实际移除的情况。有人记得这个值吗？

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?

推荐答案

SESSION但是在

实例被退回之前不会被物理删除。有没有人记得这个值？

SESSION but is not physically removed until the
instance is bounced. Does anyone remember this value offhand?

可能你指的是Oracle方面的事情已经不存在了，但是b $ b不再存在客户端还活着。

在这种情况下，您需要执行kill -9或CTRL-ALT-DEL来终止客户端

进程。


会话将保持KILLED状态，直到客户端断开与

Oracle的连接。


-


OpenVMS 7.3-1，Oracle 8.1.7.4

Syltrem
http://pages.infinit.net/syltrem （OpenVMS相关网站 - en fran？ais）

直接回复我，从我的地址中删除祖鲁语


" Fred" <无*** @ jose.com> écritdansle message de

新闻：没有************************* @ vienna7.his.com .. 。

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" <no***@jose.com> a écrit dans le message de
news:no*************************@vienna7.his.com.. .

INIT.ORA中有一个设置，它具有无意识的副作用
确保ALTER SYSTEM KILL SESSION命令立即生效。
没有这个设置，我我们已经看到会话报告在V

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中被杀死的一些情况，但在
实例被退回之前不会被物理移除。有人记得这个值吗？

SESSION but is not physically removed until the
instance is bounced. Does anyone remember this value offhand?

这篇关于当然是“杀死”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！