V$MAP_FILE

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

Column	Datatype	Description
`FILE_MAP_IDX`	`NUMBER`	Index corresponding to 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`, or `ARCHIVEFILE`)
`FILE_STRUCTURE`	`VARCHAR2(9)`	File structure (`FILE`, `RAWVOLUME`, `RAWDEVICE`, or `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