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