select
  group_number,                            -- GROUP_NUMBER NUMBER
  name,                                    -- NAME VARCHAR2(30)
  sector_size,                             -- SECTOR_SIZE NUMBER
  block_size,                              -- BLOCK_SIZE NUMBER
  allocation_unit_size,                    -- ALLOCATION_UNIT_SIZE NUMBER
  state,                                   -- STATE VARCHAR2(11)
  type,                                    -- TYPE VARCHAR2(6)
  total_mb,                                -- TOTAL_MB NUMBER
  free_mb,                                 -- FREE_MB NUMBER
  hot_used_mb,                             -- HOT_USED_MB NUMBER
  cold_used_mb,                            -- COLD_USED_MB NUMBER
  required_mirror_free_mb,                 -- REQUIRED_MIRROR_FREE_MB NUMBER
  usable_file_mb,                          -- USABLE_FILE_MB NUMBER
  offline_disks,                           -- OFFLINE_DISKS NUMBER
  compatibility,                           -- COMPATIBILITY VARCHAR2(60)
  database_compatibility,                  -- DATABASE_COMPATIBILITY VARCHAR2(60)
  voting_files                             -- VOTING_FILES VARCHAR2(1)
from
  gv$asm_diskgroup_stat
where
  inst_id = USERENV('Instance')