Indicated the tckt column the view called miscellaneous

ChapTer 14 ■ Tuning The ClusTer inTerConneCT

It’s to be noted that although there are multiple factors that can influence the remastering activity, no one reason, such as the interconnect latency, can be the only cause for this delay. The data in the output following is an indication of the overall activity of remaster operations and the time spent at various stages of the operation:

GV$DLM_TRAFFIC_CONTROLLER

Traffic controller manages the allocation of tickets to processes that need to send messages. The traffic controller manages a pool of tickets allocated during instance startup and issues tickets to requests from processes sending messages; once the messages are sent, the ticket is released back into the pool. If there is delay in message
communication and when tickets are not returned back to the pool, the pool may run out of tickets, and the processes wait to get tickets. At this time, the messages wait in a flow control queue until outstanding messages have been acknowledged and more tickets are available:

remote_rid RRID,
remote_inc RINC,
tckt_avail,
tckt_limit,
tckt_rcvd,
tckt_wait,
snd_seq_no,
snd_q_len,
snd_q_max,
snd_q_tot,
snd_q_tm_base,
snd_q_tm_wrap
FROM gv$dlm_traffic_controller
ORDER BY inst_id,
tckt_avail;

Tckt Tckt Tckt Send Q Send Q
In LNID RNID RRID RINC Avail Limit Rcvd Wait Max Total--- ---- ---- ---- ---- ----- ----- ----- ---- ---------- ---------- 1 0 1 0 4 484 500 119 NO 3 1664213 0 1 1 4 485 500 119 NO 267 925932 0 1 2 4 485 500 119 NO 266 1076223 0 2 0 4 500 500 20 YES 3 1479461 0 2 1 4 485 500 20 NO 252 4913920 0 2 2 4 498 500 20 YES 249 4889374 2 1 0 2 4 483 500 1 NO 133 1064615 1 0 1 4 484 500 1 NO 187 975192 1 2 2 4 485 500 5 NO 244 4577424 1 0 0 4 485 500 1 NO 11 2557942 1 2 1 4 499 500 5 YES 238 4604011 1 2 0 4 499 500 5 YES 6 2648164 3 2 0 2 4 481 500 0 NO 256 2927869 2 1 2 4 491 500 0 NO 777 3200388 2 1 1 4 484 500 0 NO 266 3093160 2 0 1 4 494 500 0 NO 249 2896103 2 1 0 4 495 500 0 YES 15 1757213 2 0 0 4 500 500 0 YES 9 1169226

489