49.Oracle杂记——Oracle常用动态视图V$ENQUEUE_STAT

49.Oracle杂记——Oracle常用动态视图V$ENQUEUE_STAT

视图v$enqueue_stat显示请求每个类型锁的enqueue次数。

视图描述如下：

sys@PDB1> desc v$enqueue_stat;

 Name                                                                  Null?    Type

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

 INST_ID                                                                 NUMBER

 EQ_TYPE                                                                          VARCHAR2(2)

 TOTAL_REQ#                                                                 NUMBER

 TOTAL_WAIT#                                                                         NUMBER

 SUCC_REQ#                                                                    NUMBER

 FAILED_REQ#                                                                NUMBER

 CUM_WAIT_TIME                                                                 NUMBER

 CON_ID                                                                           NUMBER

各个列描述如下：

INST_ID：实例ID

 EQ_TYPE：请求的ENQUEUE类型

 TOTAL_REQ#  ：该类型ENQUEUE的请求次数或ENQUEUE转换次数

 TOTAL_WAIT#：ENQUEUE请求或转换导致的等待次数

 SUCC_REQ#：ENQUEUE请求或转换批准的次数

 FAILED_REQ#：ENQUEUE请求或转换失败的次数

 CUM_WAIT_TIME  ：ENQUEUE请求或转换累积消耗的时间。

 CON_ID：容器ID