GV$CLUSTER_INTERCONNECTS

SELECT
INST_ID,                 -- INST_ID NUMBER
NAME_SKGXPIA,            -- NAME VARCHAR2(15)
IP_SKGXPIA,              -- IP_ADDRESS VARCHAR2(16)
decode                   -- IS_PUBLIC VARCHAR2(3)
  (PUB_SKGXPIA, 'Y', 'YES', 'N', 'NO'),
decode                   -- SOURCE VARCHAR2(31)
  (PICKED_SKGXPIA, 'OSD', 'OS dependent software', 'OCR', 'Oracle Cluster Repository', 'CI', 'cluster_interconnects parameter') 
FROM
X$SKGXPIA
home |  up  |  mailbox