请选择 进入手机版 | 继续访问电脑版

大道数据社区

 找回密码
 立即注册
Oralce 中处理 Table Lock
2020-4-14 19:25
Find Table Lock: Select * from v$Locked_Object A INNER JOIN All_Objects B ON A.object_ID = B.Object_ID Killed the Lock: Find session: Select * from v$session a inner join v$lock b on a.sid = b.sid where a.userName = '' alter system kill session 'sid, serial#'
个人分类: Oracle|70 次阅读|0 个评论

QQ|Archiver|手机版|小黑屋|大道数据社区

GMT+8, 2020-7-15 12:17 , Processed in 0.018919 second(s), 11 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

返回顶部