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 pwhere a.object_id = b.object_id and a.se...
原创
2021-07-16 09:47:14 ·
1500 阅读 ·
0 评论