查看Oracle中的锁

查看对像锁

SELECT a.LOCKED_MODE, b.object_name, b.object_type

  FROM v$locked_object a, user_objects b

 WHERE a.OBJECT_ID = b.object_id;

查看DML锁

 

SELECT username,

        v$lock.sid,

        trunc(id1 / power(2, 16)) rbs,

        bitand(id1, to_number('ffff', 'xxxx')) + 0 slot,

        id2 seq,

        lmode,

        request

   FROM v$lock, v$session

  WHERE v$lock.TYPE = 'TX'

    AND v$lock.sid = v$session.sid

    AND v$session.username = USER;

查看DDL锁

有一个意义非凡的视图可用于查看这个信息，即 DBA_DDL_LOCKS 视图

 select session_id sid, owner, name, type, mode_held held, mode_requested request

 from dba_ddl_locks;

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

转载于:http://blog.itpub.net/15742414/viewspace-611384/