GV$CONFIGURED_INTERCONNECTS

SELECT
INST_ID,                 -- INST_ID NUMBER
NAME_KSXPIA,             -- NAME VARCHAR2(15)
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  |  mailbox