PLSQL ORACLE 数据库解锁

最新推荐文章于 2023-01-09 14:27:13 发布

Java_TP

最新推荐文章于 2023-01-09 14:27:13 发布

阅读量857

点赞数

本文链接：https://blog.csdn.net/u012055814/article/details/51500332

版权

--解除数据库锁定
select b.owner TABLEOWNER, b.object_name TABLENAME, c.OSUSER LOCKBY, c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL
from v$locked_object a,dba_objects b, v$session c
where b.object_id = a.object_id AND a.SESSION_ID =c.sid;

ALTER system kill session '562, 17331' ;
ALTER system kill session '451, 64851' ;
ALTER system kill session '71, 54607' ;
ALTER system kill session '399, 59993' ;
ALTER system kill session '233, 31015' ;
ALTER system kill session '92, 40547' ;
ALTER system kill session '54, 797' ;
ALTER system kill session '44, 24051' ;