ORACLE檢視死鎖及解鎖

1:  檢視鎖表

SELECT

    sess.sid AS ID,

    sess.serial# AS NAME,

    lo.oracle_username AS 資料庫名稱,

    lo.os_user_name AS PC名稱,

    ao.object_name AS 鎖表名稱,

    lo.locked_mode

FROM

    v$locked_object lo,

    dba_objects ao,

    v$session sess

WHERE

    ao.object_id = lo.object_id

AND lo.session_id = sess.sid

2:  解鎖

alter system kill session 'id,name'