Tuning Global Cache - Expert Oracle RAC Performance Diagnostics and Tuning - page 427

CR_BUSY ,
CR_CONGESTED
FROM GV$INSTANCE_CACHE_TRANSFER
WHERE INSTANCE < 9
AND CR_BLOCK > 0
ORDER BY INST_ID,
INSTANCE;
Trg CR
In Int CLASS CR_BLOCK Blk Time CR_2HOP CR_3HOP CR_BUSY Cong
--- ---- ---------------- -------- ---------- -------- -------- -------- -------
1 7 extent map 42 15.792 13 29 0 0
7 segment header 1958 2284.246 614 1344 4 2
7 data block 1119390 89956062 433015 686375 5195 277729
7 1st level bmb 13659 1140596 6007 7652 5 292
7 undo block 3699 1693.6 3699 0 78 0
7 undo header 2055 5886.439 2055 0 102 5
7 2nd level bmb 789 1560.292 146 643 9 1
8 data block 1051046 94099141 368066 682980 1170 59377
8 segment header 1944 2417.038 480 1464 3 4
8 extent map 95 50.67 30 65 0 0
8 1st level bmb 12298 1073348 6105 6193 60 386
8 undo header 1673 5168.873 1672 1 73 3
8 3rd level bmb 6 1.654 2 4 0 0
8 2nd level bmb 734 2088.574 114 620 4 0
8 undo block 5244 2392.223 5244 0 62 3
Similar to the CR block transfer statistics, current block statistics are also visible from GV$INSTANCE_CACHE_TRANSFER
view ( MVRACPDnTap_instCacheTrans.sql script includes queries for both CR and CUR data block transfers). In Oracle
Database 11g Release 2, the scope of data displayed has been increased with additional columns.
Historical data for this view is stored in DBA_HIST_INST_CACHE_TRANSFER .
GV$GES_ENQUEUE
This view describes all locks currently maintained by the Global Enqueue Service and helps in identifying global
lockers and waiters across the cluster.
Script: MVRACPDnTap_gesLockBlockers.sql
SELECT dl.inst_id INT,
' '
|| To_char (s.sid)
||','
|| To_char (s.serial#) "SID_SER",
p.spid SPID,
dl.resource_name1 RNAME,
Decode ( Substr (dl.grant_level, 1, 8), 'KJUSERNL', 'Null',
'KJUSERCR', 'Row-S (SS)',
'KJUSERCW', 'Row-X (SX)',
'KJUSERPR', 'Share',
'KJUSERPW', 'S/Row-X (SSX)',