44.Oracle杂记——Oracle常用动态视图v$latch_children

44.Oracle杂记——Oracle常用动态视图v$latch_children

视图v$latch_children显示子latch的静态统计。

这个视图显示V$LATCH的所有列再加上CHILD#列。

视图描述如下:

sys@PDB1> desc v$latch_children;

 Name                                                                  Null?    Type

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

 ADDR                                                                                 RAW(8)

 LATCH#                                                                           NUMBER

 CHILD#                                                                  NUMBER

 LEVEL#                                                                  NUMBER

 NAME                                                                               VARCHAR2(64)

 HASH                                                                                 NUMBER

 GETS                                                                                  NUMBER

 MISSES                                                                          NUMBER

 SLEEPS                                                                  NUMBER

 IMMEDIATE_GETS                                                               NUMBER

 IMMEDIATE_MISSES                                                           NUMBER

 WAITERS_WOKEN                                                                 NUMBER

 WAITS_HOLDING_LATCH                                                              NUMBER

 SPIN_GETS                                                                      NUMBER

 SLEEP1                                                                  NUMBER

 SLEEP2                                                                  NUMBER

 SLEEP3                                                                  NUMBER

 SLEEP4                                                                 NUMBER

 SLEEP5                                                                  NUMBER

 SLEEP6                                                                  NUMBER

 SLEEP7                                                                  NUMBER

 SLEEP8                                                                  NUMBER

 SLEEP9                                                                  NUMBER

 SLEEP10                                                                 NUMBER

 SLEEP11                                                                 NUMBER

 WAIT_TIME                                                                   NUMBER

 CON_ID                                                                           NUMBER

各个列的属性描述如下:

ADDR:latch对象的地址

 LATCH#:父latch的latch号

 CHILD#:子latch号

 LEVEL# :latch 等级

 NAME:latch名字

 HASH       :latch的哈希

 GETS: 在willing to wait模式下获取latch的次数

 MISSES:在willing to wait模式下MISS latch的次数

 SLEEPS:在willing to wait模式下,睡眠的次数

 IMMEDIATE_GETS:在no-wait模式下获取latch的次数

 IMMEDIATE_MISSES:在willing to wait模式下MISS的次数

 WAITERS_WOKEN:兼容以前版本而保留

 WAITS_HOLDING_LATCH:兼容以前版本而保留

 SPIN_GETS:在willing to wait模式下,第一次尝试没有后去,后来在spinning中获取

 SLEEP1 :SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP2 :SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP3 :SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP4:SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP5:SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP6:SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP7:SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP8 :SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP9:SLEEP1~SLEEP10 兼容以前版本而保留

 SLEEP10  :SLEEP1~SLEEP10兼容以前版本而保留

 SLEEP11:SLEEP1~SLEEP10 兼容以前版本而保留

 WAIT_TIME:等待LATCH花费的时间

 CON_ID:容器ID

 

 

 

 

 

 

 

 

 

 

 

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值