oracle检查锁等待 |
select lpad(' ',decode(l.xidusn,0,3,0))||l.oracle_username User_name, o.owner,o.object_name,o.object_type,s.sid,s.serial# from v$locked_object l,dba_objects o,v$session s where l.object_id=o.object_id AND l.session_id=s.sid order by o.object_id desc |
oracle检查锁等待
最新推荐文章于 2024-01-17 23:06:41 发布