Tuning the Cluster Interconnect - Expert Oracle RAC Performance Diagnostics and Tuning - page 480

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
In the preceding output, there are several processes that have the TCKT_WAIT columns that say YES . This indicates
that the pool has run out of tickets. When several processes go into the wait state, it could cause the GCS to hang.
It is important to monitor the ticket usage and ensure that there are enough tickets available, indicated in the
TCKT_AVAIL column.
GV$DLM_MISC
Although the view is called miscellaneous, it contains some of the most vital statistics related to messages. It's
probably the only view that gives detailed statistics on the message traffic between instances. Earlier in this chapter,
we discussed AST, BAST, and AAST type of messages. These statistics are all maintained in this view.