GV$ASM_CLIENT
select inst_id, -- INST_ID NUMBER gn_kfncl, -- GROUP_NUMBER NUMBER instname_kfncl, -- INSTANCE_NAME VARCHAR2(64) dbname_kfncl, -- DB_NAME VARCHAR2(8) decode -- STATUS VARCHAR2(12) (status_kfncl, 1, 'CONNECTED', 2, 'DISCONNECTED', 3, 'BROKEN'), softver_kfncl, -- SOFTWARE_VERSION VARCHAR2(60) compver_kfncl -- COMPATIBLE_VERSION VARCHAR2(60) from x$kfncl

home |  up  |  mailbox