select
  name,                                    -- NAME VARCHAR2(70)
  group_number,                            -- GROUP_NUMBER NUMBER
  file_number,                             -- FILE_NUMBER NUMBER
  file_incarnation,                        -- FILE_INCARNATION NUMBER
  alias_index,                             -- ALIAS_INDEX NUMBER
  alias_incarnation,                       -- ALIAS_INCARNATION NUMBER
  parent_index,                            -- PARENT_INDEX NUMBER
  reference_index,                         -- REFERENCE_INDEX NUMBER
  alias_directory,                         -- ALIAS_DIRECTORY VARCHAR2(1)
  system_created                           -- SYSTEM_CREATED VARCHAR2(1)
from
  gv$asm_alias
where
  inst_id = USERENV('Instance')