FILE_MAPPING

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SYSTEM
Range of values	true | false
Basic	No

FILE_MAPPING specifies whether or not file mapping is enabled. The FMON background process is started to manage the mapping information when file mapping is enabled.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘FILE_MAPPING’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
file_mapping	FALSE	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	enable file mapping

Oracle initializatoin parameters