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') 
from
x$kfncl
home |  up  |  mailbox