Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$MAP_FILE_EXTENT

V$MAP_FILE_EXTENT displays 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

  • NONE

ELEM_IDX NUMBER Index in V$MAP_ELEMENT corresponding to the element where the file extent resides