原文地址::https://blog.csdn.net/qq_37980551/article/details/89387822
相关文章
1、Oracle锁表与解锁 对象锁与解锁----https://www.cnblogs.com/yx007/p/9077939.html
2、怎样在oracle 给表加锁??----https://zhidao.baidu.com/question/497773545.html
3、Oracle 锁表的原因,及解决方案----https://blog.csdn.net/seelye/article/details/80775052?utm_medium=distribute.pc_relevant.none-task-blog-OPENSEARCH-8.edu_weight&depth_1-utm_source=distribute.pc_relevant.none-task-blog-OPENSEARCH-8.edu_weight
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;
- 1
- 2
- 3
执行sql
select *
from v$session t1, v$locked_object t2
where t1.sid = t2.SESSION_ID;
- 1
- 2
- 3
如有记录表示有LOCK ,记录下SID和serial# ,
將记录的ID替换下面的SID,serial,即可解除LOCK
alter system kill session '293,37453';
- 1
要用system账号登入