http://docs.oracle.com/database/121/REFRN/refrn30109.htm

泉州網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)公司,泉州網(wǎng)站設(shè)計制作，有大型網(wǎng)站制作公司豐富經(jīng)驗。已為泉州千余家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\成都外貿(mào)網(wǎng)站制作要多少錢，請找那個售后服務(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: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

ADDR： latch對象的物理地址。

LATCH#：子latch的父latch號。

CHILD#：子latch號，對于每一個父latch，子latch都是唯一的。

LEVEL#：latch級別。

NAME：latch名稱。

HASH：latch哈希值。

GETS：在Willing-to-waits模式下請求latch次數(shù)。

MISSES：在Willing-to-waits模式下發(fā)生等待時請求latch次數(shù)。

SLEEPS：當發(fā)生latch等待導致session休眠時請求latch的次數(shù)。

IMMEDIATE_GETS：no-wait模式下請求latch次數(shù)。

IMMEDIATE_MISSES：請求no-wait latch失敗的次數(shù)。

WAITERS_WOKEN：該列已經(jīng)被當前版本棄用，保留是為了向前兼容。

WAITS_HOLDING_LATCH：該列已經(jīng)被當前版本棄用，保留是為了向前兼容。

SPIN_GETS：當spinning時，最終成功請求Willing-to-wait latch次數(shù)

WAIT_TIME：latch等待消耗的時間（以微秒計算）。

CON_ID：表明數(shù)據(jù)的從屬關(guān)系，0 表示那些行屬于CDB的數(shù)據(jù)，1 表示僅屬于root，n 表示適用的container ID。

 

新聞標題：V$LATCH_CHILDREN視圖
網(wǎng)站網(wǎng)址：http://jinyejixie.com/article10/ghdodo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供標簽優(yōu)化、品牌網(wǎng)站設(shè)計、全網(wǎng)營銷推廣、關(guān)鍵詞優(yōu)化、網(wǎng)站策劃、動態(tài)網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)