【转】Oracle:检查被锁数据在V$LOCK中的情况

/* Formatted on 12/27/2011 2:55:58 PM (QP5 v5.163.1008.3004) */
SELECT (SELECT username
          FROM v$session
         WHERE sid = v$lock.sid)
          username,
       sid,
       id1,
       id2,
       lmode,
       request,
       block,
       v$lock.TYPE
  FROM v$lock
WHERE sid IN (SELECT sid
                 FROM v$mystat
                WHERE ROWNUM = 1)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26892340/viewspace-721932/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26892340/viewspace-721932/