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;

SID SERIAL# MACHINE TERMINAL OBJECT_NAME LOCKED_MODE
---------- ---------- ---------------------------------------------------------------- ------------------------------ -------------------------------------------------------------------------------------------------------------------------------- -----------
958 517 WORKGROUP\DELL-158 DELL-158 E_GRADEINFO 3

SQL>

ITPub博客

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

最新文章