select group_number, -- GROUP_NUMBER NUMBER usergroup_number, -- USERGROUP_NUMBER NUMBER compound_index, -- COMPOUND_INDEX NUMBER incarnation, -- INCARNATION NUMBER owner_number, -- OWNER_NUMBER NUMBER owner_incarnation, -- OWNER_INCARNATION NUMBER name -- NAME VARCHAR2(64) from gv$asm_usergroup where inst_id = USERENV('Instance')