oracle v$enqueue_lock,50.蛤蟆的Oracle杂记——Oracle常用动态视图V$ENQUEUE_LOCK

50.蛤蟆的Oracle杂记——Oracle常用动态视图V$ENQUEUE_LOCK

视图v$enqueue_lock显示了被enqueue 状态对象拥有的所有锁。

视图描述如下：

idle> desc v$enqueue_lock;

Name                                                           Null?  Type

------------------------------------------------------------- ------------------------------------

ADDR                                                                      RAW(8)

KADDR                                                                    RAW(8)

SID                                                                  NUMBER

TYPE                                                                        VARCHAR2(2)

ID1                                                                           NUMBER

ID2                                                                           NUMBER

LMODE                                                                   NUMBER

REQUEST                                                                NUMBER

CTIME                                                                     NUMBER

BLOCK                                                                     NUMBER

CON_ID                                                                 NUMBER

各个列的含义描述如下：

ADDR：锁状态对象的地址

KADDR：锁的地址

SID ：持有或获取锁的会话ID

TYPE：锁类型

ID1          ：锁的参数1

ID2          ：锁的参数2

LMODE：会话持有锁的模式

REQUEST：进程请求锁的模式

CTIME：当前模式批准的时间

BLOCK：是否阻塞其他锁

CON_ID：容器ID