select
  group_number,                            -- GROUP_NUMBER NUMBER
  file_number,                             -- FILE_NUMBER NUMBER
  compound_index,                          -- COMPOUND_INDEX NUMBER
  incarnation,                             -- INCARNATION NUMBER
  block_size,                              -- BLOCK_SIZE NUMBER
  blocks,                                  -- BLOCKS NUMBER
  bytes,                                   -- BYTES NUMBER
  space,                                   -- SPACE NUMBER
  type,                                    -- TYPE VARCHAR2(64)
  redundancy,                              -- REDUNDANCY VARCHAR2(6)
  striped,                                 -- STRIPED VARCHAR2(6)
  creation_date,                           -- CREATION_DATE DATE
  modification_date,                       -- MODIFICATION_DATE DATE
  redundancy_lowered,                      -- REDUNDANCY_LOWERED VARCHAR2(1)
  permissions,                             -- PERMISSIONS VARCHAR2(16)
  user_number,                             -- USER_NUMBER NUMBER
  user_incarnation,                        -- USER_INCARNATION NUMBER
  usergroup_number,                        -- USERGROUP_NUMBER NUMBER
  usergroup_incarnation,                   -- USERGROUP_INCARNATION NUMBER
  primary_region,                          -- PRIMARY_REGION VARCHAR2(4)
  mirror_region,                           -- MIRROR_REGION VARCHAR2(4)
  hot_reads,                               -- HOT_READS NUMBER
  hot_writes,                              -- HOT_WRITES NUMBER
  hot_bytes_read,                          -- HOT_BYTES_READ NUMBER
  hot_bytes_written,                       -- HOT_BYTES_WRITTEN NUMBER
  cold_reads,                              -- COLD_READS NUMBER
  cold_writes,                             -- COLD_WRITES NUMBER
  cold_bytes_read,                         -- COLD_BYTES_READ NUMBER
  cold_bytes_written                       -- COLD_BYTES_WRITTEN NUMBER
from
  gv$asm_file
where
  inst_id = USERENV('Instance')