V$LATCH_CHILDREN視圖
http://docs.oracle.com/database/121/REFRN/refrn30109.htm
泉州網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)公司,泉州網(wǎng)站設(shè)計(jì)制作，有大型網(wǎng)站制作公司豐富經(jīng)驗(yàn)。已為泉州千余家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\成都外貿(mào)網(wǎng)站制作要多少錢，請(qǐng)找那個(gè)售后服務(wù)好的泉州做網(wǎng)站的公司定做！
V$LATCH_CHILDREN
V$LATCH_CHILDREN displays statistics about child latches. This view includes all columns of V$LATCH plus the CHILD# column. Note that child latches have the same parent if their LATCH# columns match each other.
| Column | Datatype | Description |
|---|---|---|
ADDR | RAW(4 | 8) | Address of the latch object |
LATCH# | NUMBER | Latch number of the parent latch |
CHILD# | NUMBER | Child latch number (unique only to each parent latch) |
LEVEL# | NUMBER | Latch level |
NAME | VARCHAR2(64) | Latch name |
HASH | NUMBER | Latch hash |
GETS | NUMBER | Number of times the latch was requested in willing-to-wait mode |
MISSES | NUMBER | Number of times the latch was requested in willing-to-wait mode and the requester had to wait |
SLEEPS | NUMBER | Number of times a willing-to-wait latch request resulted in a session sleeping while waiting for the latch |
IMMEDIATE_GETS | NUMBER | Number of times a latch was requested in no-wait mode |
IMMEDIATE_MISSES | NUMBER | Number of times a no-wait latch request did not succeed (that is, missed) |
WAITERS_WOKEN | NUMBER | This column has been deprecated and is present only for compatibility with previous releases of Oracle. No data is accumulated for this column; it will always have a value of zero. |
WAITS_HOLDING_LATCH | NUMBER | This column has been deprecated and is present only for compatibility with previous releases of Oracle. No data is accumulated for this column; it will always have a value of zero. |
SPIN_GETS | NUMBER | Willing-to-wait latch requests which missed the first try but succeeded while spinning |
SLEEP[1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11] | NUMBER | These columns have been deprecated and are present only for compatibility with previous releases of Oracle. No data is accumulated for these columns; they will always have a value of zero. As a substitute for these columns you can query the appropriate rows of the V$EVENT_HISTOGRAM view where the EVENT column has a value of latch free or latch:%. |
WAIT_TIME | NUMBER | Elapsed time spent waiting for the latch (in microseconds) |
CON_ID | NUMBER | The ID of the container to which the data pertains. Possible values include:
|
ADDR： latch對(duì)象的物理地址。
LATCH#：子latch的父latch號(hào)。
CHILD#：子latch號(hào)，對(duì)于每一個(gè)父latch，子latch都是唯一的。
LEVEL#：latch級(jí)別。
NAME：latch名稱。
HASH：latch哈希值。
GETS：在Willing-to-waits模式下請(qǐng)求latch次數(shù)。
MISSES：在Willing-to-waits模式下發(fā)生等待時(shí)請(qǐng)求latch次數(shù)。
SLEEPS：當(dāng)發(fā)生latch等待導(dǎo)致session休眠時(shí)請(qǐng)求latch的次數(shù)。
IMMEDIATE_GETS：no-wait模式下請(qǐng)求latch次數(shù)。
IMMEDIATE_MISSES：請(qǐng)求no-wait latch失敗的次數(shù)。
WAITERS_WOKEN：該列已經(jīng)被當(dāng)前版本棄用，保留是為了向前兼容。
WAITS_HOLDING_LATCH：該列已經(jīng)被當(dāng)前版本棄用，保留是為了向前兼容。
SPIN_GETS：當(dāng)spinning時(shí)，最終成功請(qǐng)求Willing-to-wait latch次數(shù)
WAIT_TIME：latch等待消耗的時(shí)間（以微秒計(jì)算）。
CON_ID：表明數(shù)據(jù)的從屬關(guān)系，0 表示那些行屬于CDB的數(shù)據(jù)，1 表示僅屬于root，n 表示適用的container ID。
新聞名稱：V$LATCH_CHILDREN視圖
新聞來源：http://www.jiaotiyi.com/article/ghdodo.html