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