Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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