解决Oracle 表锁定

 

 

SELECT B.OWNER, B.OBJECT_NAME, A.SESSION_ID, A.LOCKED_MODE
  FROM V$LOCKED_OBJECT A, DBA_OBJECTS B
 WHERE B.OBJECT_ID = A.OBJECT_ID

SELECT B.USERNAME, B.SID, B.SERIAL#, LOGON_TIME
        FROM V$LOCKED_OBJECT A, V$SESSION B
       WHERE A.SESSION_ID = B.SID
       ORDER BY B.LOGON_TIME
           
--查询锁定表
  SELECT B.USERNAME, B.SID, B.SERIAL#, LOGON_TIME
    FROM V$LOCKED_OBJECT A, V$SESSION B
   WHERE A.SESSION_ID = B.SID
   ORDER BY B.LOGON_TIME
           
--alter system kill session 'sid,serial#';
--把锁给KILL掉 解锁
 ALTER SYSTEM KILL SESSION '550,135';