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