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:
|
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 |