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