#描述:当执行如下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