oracle 查看表被锁和如何解锁
前提:该用户必须拥有DBA权限,否则提示找不到表和视图
一,oracle 查看哪些表被锁
select c.sid, c.serial#, c.username, c.osuser, b.owner, b.object_name, a.locked_mode, p.spid
from v$locked_object a, dba_objects b, v$session c, v$process p
where a.object_id = b.object_id
and a.se...
原创
2021-07-16 09:47:14 ·
1567 阅读 ·
0 评论