GV$ASM_FILE

select
inst_id,                 -- INST_ID NUMBER
group_kffil,             -- GROUP_NUMBER NUMBER
number_kffil,            -- FILE_NUMBER NUMBER
compound_kffil,          -- COMPOUND_INDEX NUMBER
incarn_kffil,            -- INCARNATION NUMBER
blksiz_kffil,            -- BLOCK_SIZE NUMBER
blkcnt_kffil,            -- BLOCKS NUMBER
filsiz_kffil,            -- BYTES NUMBER
filspc_kffil,            -- SPACE NUMBER
sftype_kffil,            -- TYPE VARCHAR2(64)
decode                   -- REDUNDANCY VARCHAR2(6)
  (redun_kffil, 17, 'UNPROT', 18, 'MIRROR', 19, 'HIGH', 35, 'PARITY', 36, 'PARITY', 37, 'PARITY', 38, 'PARITY'),
decode                   -- STRIPED VARCHAR2(6)
  (bitand (fdflg_kffil, 2), 2, 'FINE', 'COARSE'),
crdate_kffil,            -- CREATION_DATE DATE
mddate_kffil,            -- MODIFICATION_DATE DATE
decode                   -- REDUNDANCY_LOWERED VARCHAR2(1)
  (thinned_kffil, 0, 'U', 4294967295, 'N', 'Y') 
from
x$kffil 
where
incarn_kffil <> 0 and number_kffil > 255
home |  up  |  mailbox