ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Kill Session Not Release Locks

Kill Session Not Release Locks

原创 Linux操作系统 作者:yanggq 时间:2019-06-15 13:12:08 0 删除 编辑
Alter system kill session ........

Problem Description

-------------------

You have killed a session at the os level. Now, the session is showing "killed" in v$session but v$access is showing objects locked by this session id and v$lock shows locks held by this sid.

Solution Description

--------------------

You may have killed the client process and there is still a shadow process for this session running. The shadow process can be tricky to identify. It may take considerable searching by the dba who is familiar with the os and database environment to identify the process.

You might look for processes with a parent pid of 1, meaning that they are owned by the system. Also, look for processes with a start time that matches the start time of the killed process.

Explanation

-----------

Even though you shouldn't kill the session at the os level before killing it in Oracle, Oracle should release locks and cleanup after the session is killed at the os level. If locks are not being released, it is an indication that there are other os processes running that are associated with the session.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26706/viewspace-64603/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2002-10-29

  • 博文量
    78
  • 访问量
    50748