select
  group_number,                            -- GROUP_NUMBER NUMBER
  entry_number,                            -- ENTRY_NUMBER NUMBER
  redundancy,                              -- REDUNDANCY VARCHAR2(6)
  stripe,                                  -- STRIPE VARCHAR2(6)
  system,                                  -- SYSTEM VARCHAR2(1)
  name,                                    -- NAME VARCHAR2(30)
  primary_region,                          -- PRIMARY_REGION VARCHAR2(4)
  mirror_region                            -- MIRROR_REGION VARCHAR2(4)
from
  gv$asm_template
where
  inst_id = USERENV('Instance')