/* 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)

【轉】Oracle:檢查被鎖資料在V$LOCK中的情況

相關文章