GV$CONFIGURED_INTERCONNECTS definition in Oracle Database 11.2

GV$CONFIGURED_INTERCONNECTS

SELECT
  INST_ID,                                 -- INST_ID NUMBER
  NAME_KSXPIA,                             -- NAME VARCHAR2(35)
  IP_KSXPIA,                               -- IP_ADDRESS VARCHAR2(16)
  decode(                                  -- IS_PUBLIC VARCHAR2(3)
    PUB_KSXPIA, 'Y', 'YES', 'N', 'NO'),
  decode(                                  -- SOURCE VARCHAR2(31)
    PICKED_KSXPIA, 'OSD', 'OS dependent software', 'OCR', 'Oracle Cluster Repository', 'CI', 'cluster_interconnects parameter') 
FROM
  X$KSXPIA

home | up