V$MAP_FILE_EXTENT
contains a list of all file extent mapping structures in the shared memory of the instance.
Column | Datatype | Description |
---|---|---|
FILE_MAP_IDX |
NUMBER |
File index (corresponds to FILE_MAP_IDX in V$MAP_FILE ) |
EXT_NUM |
NUMBER |
File extent number |
EXT_ELEM_OFF |
NUMBER |
Element offset in HKB |
EXT_SIZE |
NUMBER |
File extent size in HKB |
EXT_FILE_OFF |
NUMBER |
File Offset in HKB |
EXT_TYPE |
VARCHAR2(6) |
File Extent Type (DATA , PARITY , or NONE ) |
ELEM_IDX |
NUMBER |
Index in V$MAP_ELEMENT corresponding to the element where the file extent resides |