查询Oracle RAC Cache Fusion通信的私有网络
if IP/Public/Source at End snap is different a '*' is displayedBegin End Interface IP Address Pub Source IP Pub Src eth1:1169.254.218.13N在Oracle11g中可以查询X$KSXPIA也能找到用于Cache Fusion的网络接口
SQL> select * from x$ksxpia;ADDR INDX INST_ID PUB_KSXPIA PICKED_KSXPIA NAME_KSXPIA IP_KSXPIA-------------------- ---------- ---------- ---------- --------------- --------------- ----------------00007F1525B98998 0 1 N GPnP eth1:1 169.254.218.1300007F1525B98998 1 1 Y GPnP eth0 192.168.1.5100007F1525B98998 2 1 Y GPnP eth0:1 192.168.1.15100007F1525B98998 3 1 Y GPnP eth0:2 192.168.1.59