V$MAP_FILE

V$MAP_FILE displays a list of all file mapping structures in the shared memory of the instance.

Column Datatype Description
FILE_MAP_IDX NUMBER Index corresponding to the file
FILE_CFGID VARCHAR2(256) Configuration ID (N/A if configuration ID is not supported)
FILE_STATUS VARCHAR2(7) Status of the mapping information:

  • VALID - File mapping information is latest

  • INVALID - Mapping needs to be refreshed
FILE_NAME VARCHAR2(256) Absolute file name
FILE_TYPE VARCHAR2(11) File type:

  • DATAFILE

  • SPFILE

  • TEMPFILE

  • CONTROLFILE

  • LOGFILE

  • ARCHIVEFILE
FILE_STRUCTURE VARCHAR2(9) File structure:

  • FILE

  • RAWVOLUME

  • RAWDEVICE

  • NONE
FILE_SIZE NUMBER File size in HKB (half KB)
FILE_NEXTS NUMBER Number of file extents in the file (not necessarily the same as the number of file extents mapped)
LIB_IDX NUMBER Index of mapping library claiming ownership of the file