Oracle Lock

查有哪些哪些程序和Session 有鎖. 

selectC.sid,C.serial#,B.object_name,C.username,C.machine,C.terminal,C.program

from Gv$locked_object A,all_objectsB,Gv$session C where A.session_id = C.sid and

A.object_id = B.object_id;

 

查引起鎖定的是那個Session,以及具體的機器名和程序,避免誤殺System進程Session.                                                                                             selectC.sid,C.serial#,C.username,C.machine,C.terminal,C.program from dba_waiters

A,v$session C where A.holding_session= C.sid

alter system kill session‘159,17622';   

參考參考:可以知道具體的 Sql語句 
    

 selectC.sid,C.serial#,C.username,C.machine,C.terminal,C.program,B.SQL_TEXT

from dba_waiters  A,V$SQLB,v$session C where A.WAITING_session = C.sid AND

B.SQL_ID=C.SQL_ID

從上面的圖片和SQL可以具體的指導引起Session鎖定的具體的SQL.