Oracle数据库表被锁解决办法
-- 查找被锁的表
select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session s
where l.object_id = o.object_id and l.session_id=s.sid;
-- 将被锁的表的session kill了
alter system kill ...
原创
2020-01-15 18:12:40 ·
509 阅读 ·
0 评论