#描述：当执行如下SQL
select * From XXX for Updata
发现表“XXX”被锁定
#只需要执行如下SQL 查看锁定该表的用户
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.
object_id = o.
object_id
AND l.session_id
= s.sid;
#效果图如下
转载于:https://www.cnblogs.com/zhibu/p/7150779.html
