oracle数据库查询锁表以及解锁
– 查询哪些对象被锁
select object_name,machine,s.sid,s.serial#,l.*
from vlockedobjectl,dbaobjectso,vlocked_object l,dba_objects o ,vlockedobjectl,dbaobjectso,vsession s
where l.object_id = o.object_id and l.session_id=s.sid;
select t.* from v$locked_object t ;
–
原创
2020-08-18 16:30:29 ·
145 阅读 ·
0 评论