select
group_number, -- GROUP_NUMBER NUMBER
instance_name, -- INSTANCE_NAME VARCHAR2(64)
db_name, -- DB_NAME VARCHAR2(8)
status, -- STATUS VARCHAR2(12)
software_version, -- SOFTWARE_VERSION VARCHAR2(60)
compatible_version -- COMPATIBLE_VERSION VARCHAR2(60)
from
gv$asm_client
where
inst_id = USERENV('Instance')