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

 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>
请使用浏览器的分享功能分享到微信等