Database Reference
In-Depth Information
Step 1
Does the cluster have the interconnect configured correctly?
Instance Name IP Address IS_
-------- ---------- --------------- ---
1 eth2:1 169.254.14.121 NO
1 eth3:1 169.254.140.97 NO
2 eth2:1 169.254.12.119 NO
2 eth3:1 169.254.246.237 NO
Step 2
The interconnect has been configured correctly, and the interconnect definitions are recorded in the GPnP file. In
checking the data transfer rates across the interconnect, the following latency numbers are seen:
Script: MVRACPDnTap_blksndtime.sql
SELECT
B1.INST_ID INT,
B2.VALUE "gc cr BR",
B1.VALUE "gc cr BRT",
B4.VALUE "gc cur BR",
b3.value "gc cur BRT",
((B1.VALUE/B2.VALUE ) *10) "Avg CR BRT(ms)",
((B3.VALUE/B4.VALUE ) *10) "Avg CUR BRT(ms)"
FROM GV$SYSSTAT B1,
GV$SYSSTAT B2,
GV$SYSSTAT B3,
GV$SYSSTAT B4
WHERE B1.NAME = 'gc cr block receive time'
AND B2.NAME = 'gc cr blocks received'
AND B3.NAME = 'gc current block receive time'
AND B4.NAME = 'gc current blocks received'
AND B1.INST_ID = B2.INST_ID
AND B1.INST_ID = B3.INST_ID
AND B1.INST_ID = B4.INST_ID
ORDER BY 1
/
Avg CR Avg CUR
In gc cr BR gc cr BRT gc cur BR gc cur BRT BRT (ms) BRT (ms)
---- -------- --------- --------- ---------- --------- ---------
1 164525 168021 50238 84114 10.21 16.74
2 178217 198596 53490 60261 11.14 11.27
3 112649 180146 40128 58259 15.99 14.52
4 108053 251629 48928 69379 23.29 14.18
5 249861 312446 41881 71759 12.50 17.13
6 461630 794437 170375 184664 17.21 10.84
Search WWH ::
Custom Search