oracle如何查询表被锁定状态

[xf_zhouwenjun]

同上

[hyrongg]

刚刚不是才问过的吗？干嘛，倒分？

[月夜雪]

SELECT /*+ rule */ 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,xidusn DESC

[yangzeDB]

SELECT *
FROM V$LOCKED_OBJECT S
WHERE S.OBJECT_ID IN
(SELECT OBJECT_ID FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE');

[hyrongg]

SELECT /*+ rule */ 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,xidusn DESC
-----------------------------------------------------
SELECT * 
  FROM V$LOCKED_OBJECT S 
WHERE S.OBJECT_ID IN 
  (SELECT OBJECT_ID FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE');