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;
执行sql
select *
from v$session t1, v$locked_object t2
where t1.sid = t2.SESSION_ID;
如有记录表示有LOCK ,记录下SID和serial# ,
將记录的ID替换下面的SID,serial,即可解除LOCK
alter system kill session '293,37453';
要用system账号登入