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')