Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

B28320-03
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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