ORACLE 查找锁

1.查找被锁定的资源
  SELECT * FROM v$lock where request > 0;
2.查找引起锁的语句
  SELECT DECODE(request,0,'Holder: ','Waiter: ') ||sid sess,
  id1, id2, lmode, request, type,BLOCK
  FROM V$LOCK
  WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM V$LOCK WHERE request > 0)
  ORDER BY id1, request;

转载于:https://blog.51cto.com/rainzl/1218890