關聯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>