1、檢視鎖是否存在
select sess.sid,
    sess.serial#,
    lo.oracle_username,
    lo.os_user_name,
    ao.object_name,
    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 '738,1429';

注：如果kill session報ora-00031:標記要終止的會話，需要在作業系統級別kill spid
SELECT S.USERNAME,S.OSUSER,S.SID,S.SERIAL#,P.SPID FROM V$SESSION S,V$PROCESS
P WHERE S.PADDR=P.ADDR AND S.USERNAME IS NOT NULL;

USERNAME OSUSER SID SERIAL# SPID
------------------------------ ------------------------------ ---------- ---------- ------------------------
SYS oracle 193    475   11926
SYS oracle 232 279 11974

kill -9 11926

檢視Oracle鎖並且釋放鎖

相關文章