48.Oracle杂记——Oracle常用动态视图v$latchholder

48.Oracle杂记——Oracle常用动态视图v$latchholder

视图v$latchholder 显示当前latch持有者的信息。

视图描述如下：

sys@PDB1> desc v$latchholder

 Name                                                                  Null?    Type

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

 PID                                                                           NUMBER

 SID                                                                           NUMBER

 LADDR                                                                               RAW(8)

 NAME                                                                               VARCHAR2(64)

 GETS                                                                                  NUMBER

 CON_ID                                                                           NUMBER

每个列的含义描述：

PID：持有LATCH的进程ID

 SID：拥有LATCH的会话ID

 LADDR：LATCH地址

 NAME：LATCH的名字

 GETS：在WAIT模式或NO-WAIT模式下，获取LATCH的次数

 CON_ID：容器ID