关联v$session,v$locked_object,dba_objects查出锁死会话及对象

最新推荐文章于 2021-06-07 15:55:15 发布

clg10051

最新推荐文章于 2021-06-07 15:55:15 发布

阅读量354

点赞数

文章标签：数据库

select c.sid,c.serial#,c.machine,c.terminal,b.object_name,a.locked_mode from v$locked_object a,dba_objects b,v$session c where a.object_id=b.object_id and c.sid=a.session_id;

       SID    SERIAL# MACHINE                                                          TERMINAL                       OBJECT_NAME                                  LOCKED_MODE
---------- ---------- ---------------------------------------------------------------- ------------------------------ -------------------------------------------------------------------------------------------------------------------------------- -----------
       958        517 WORKGROUP\DELL-158                                               DELL-158                       E_GRADEINFO                            3
       919        232 Dev12-PC                                                         unknown                        E_GRADEINFO                            3

SQL> alter system kill session '919,232';

系统已更改。

SQL> select c.sid,c.serial#,c.machine,c.terminal,b.object_name,a.locked_mode from v$locked_object a,dba_objects b,v$session c where a.object_id=b.object_id and c.sid=a.session_id;

SQL>

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

转载于:http://blog.itpub.net/9240380/viewspace-667810/