GV$MAP_FILE_EXTENT
select inst_id, -- INST_ID NUMBER file_idx, -- FILE_MAP_IDX NUMBER ext_num, -- EXT_NUM NUMBER ext_dev_off, -- EXT_ELEM_OFF NUMBER ext_size, -- EXT_SIZE NUMBER ext_file_off, -- EXT_FILE_OFF NUMBER decode -- EXT_TYPE VARCHAR2(6) (ext_type, 1, 'DATA', 2, 'PARITY', 3, 'NONE'), elem_idx -- ELEM_IDX NUMBER from x$ksfmfileext where elem_idx != 4294967295

home |  up  |  mailbox