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