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 must 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
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data