select
  group_number,                            -- GROUP_NUMBER NUMBER
  volume_name,                             -- VOLUME_NAME VARCHAR2(30)
  compound_index,                          -- COMPOUND_INDEX NUMBER
  size_mb,                                 -- SIZE_MB NUMBER
  volume_number,                           -- VOLUME_NUMBER NUMBER
  redundancy,                              -- REDUNDANCY VARCHAR2(6)
  stripe_columns,                          -- STRIPE_COLUMNS NUMBER
  stripe_width_k,                          -- STRIPE_WIDTH_K NUMBER
  state,                                   -- STATE VARCHAR2(8)
  file_number,                             -- FILE_NUMBER NUMBER
  incarnation,                             -- INCARNATION NUMBER
  drl_file_number,                         -- DRL_FILE_NUMBER NUMBER
  resize_unit_mb,                          -- RESIZE_UNIT_MB NUMBER
  usage,                                   -- USAGE VARCHAR2(30)
  volume_device,                           -- VOLUME_DEVICE VARCHAR2(256)
  mountpath                                -- MOUNTPATH VARCHAR2(1024)
from
  gv$asm_volume
where
  inst_id = USERENV('Instance')