![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
枫叶的记忆
勤奋 欣赏 包容 感恩
展开
-
Oracle数据库表解锁方法
select * from V$session t1, SYS.V_$LOCKED_OBJECT t2 where t2.session_Id = t1.sid;--查出锁表的session及序号alter system kill session '115,33246'--其中115是sid,33246为serial原创 2015-04-07 21:49:28 · 534 阅读 · 0 评论 -
查看和解锁的语句
查看和解锁的语句select * from v$locked_object;select * from v$session where sid in ((v$locked_object[SESSION_ID]));alter system kill session '〔v$locked_object[SESSION_ID]〕,(v$session[SERIAL#])';select原创 2015-06-07 14:22:13 · 500 阅读 · 0 评论