../E40402-16.epub /> ../E40402-16.mobi />

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