oracle 表解锁

全部解锁

declare 
v_sid V$LOCKED_OBJECT.SESSION_ID%type;
v_ser V$SESSION.SERIAL#%type;
ls_sql varchar2(1000);
i number;
j number;
begin
select count(distinct session_id) into j from V$LOCKED_OBJECT A, V$SESSION S WHERE A.SESSION_ID=S.SID;
i:=1;
for i in 1..j loop
select  SESSION_ID,SERIAL# into v_sid,v_ser from V$LOCKED_OBJECT A, V$SESSION S WHERE A.SESSION_ID=S.SID and rownum=1;
ls_sql := 'alter system kill session '||''''||v_sid||','||v_ser||'''';
execute immediate ls_sql;
end loop;
end;

单表解锁

SELECT S.SID,
       S.SERIAL#,
       L.OBJECT_ID,
       L.ORACLE_USERNAME,
       L.OS_USER_NAME,
       D.OBJECT_NAME
  FROM V$LOCKED_OBJECT L, V$SESSION S, DBA_OBJECTS D
 WHERE L.SESSION_ID = S.SID
   AND L.OBJECT_ID = D.OBJECT_ID;

ALTER SYSTEM KILL SESSION 'SID,SERIAL#';