Oracle 解锁表

ORACLE解锁表

SELECT * FROM V$SESSION T1, V$LOCKED_OBJECT T2 WHERE T1.SID = T2.SESSION_ID; 
SELECT S.PROCESS,
  S.SID,
  S.SERIAL#,
  B.OBJECT_NAME,
  B.SUBOBJECT_NAME,
  A.LOCKED_MODE,
  S.OSUSER,
  S.LOGON_TIME,
  S.MACHINE,
  S.PROGRAM,
  S.SQL_ADDRESS,
  S.SQL_HASH_VALUE           
FROM V$LOCKED_OBJECT A, DBA_OBJECTS B, V$SESSION S
WHERE A.OBJECT_ID = B.OBJECT_ID
AND A.SESSION_ID = S.SID
   
ALTER SYSTEM KILL SESSION '1564,43919' IMMEDIATE;