數(shù)據(jù)字典視圖之:v$dlm_traffic_controller
作者:
eygle |
English Version 【轉(zhuǎn)載時(shí)請以超鏈接形式標(biāo)明文章
出處和作者信息及
本聲明】
鏈接:
http://www.eygle.com/archives/2008/06/v_dlm_traffic_controller.html
v$dlm_traffic_controller用于控制RAC中DLM的流量,其視圖結(jié)構(gòu)為:
SELECT inst_id, kjitrftlid, kjitrftrid, kjitrftrrd, kjitrftinc, kjitrftta,
kjitrfttl, kjitrfttr,
DECODE (kjitrfttw, 0, 'NO ', 'YES '), kjitrftss,
kjitrftsr, kjitrftsql, kjitrftsqm, kjitrftsqt, kjitrftqtb, kjitrftqtw,
kjitrftst, kjitrftpxy
FROM x$kjitrft
其字段對應(yīng)關(guān)系為:
SQL> desc v$dlm_traffic_controller
Name Null? Type
----------------------------------------- -------- --------------------------------------------
LOCAL_NID NUMBER
REMOTE_NID NUMBER
REMOTE_RID NUMBER
REMOTE_INC NUMBER
TCKT_AVAIL NUMBER
TCKT_LIMIT NUMBER
TCKT_RCVD NUMBER
TCKT_WAIT VARCHAR2(10)
SND_SEQ_NO NUMBER
RCV_SEQ_NO NUMBER
SND_Q_LEN NUMBER
SND_Q_MAX NUMBER
SND_Q_TOT NUMBER
SND_Q_TM_BASE NUMBER
SND_Q_TM_WRAP NUMBER
STATUS NUMBER
SND_PROXY NUMBER
以上數(shù)據(jù)來自O(shè)racle10g 10.2.0.4環(huán)境。
-The End-