FIXED_DATE

Property	Description
Parameter type	String
Syntax	FIXED_DATE = [YYYY-MM-DD-HH24:MI:SS (or the default Oracle date format) | NONE]
Default value	There is no default value.
Modifiable	ALTER SYSTEM
Basic	No

FIXED_DATE enables you to set a constant date that SYSDATE will always return instead of the current date. To undo a fixed date setting, specify FIXED_DATE=NONE. This parameter is useful primarily for testing. The value can be in the format shown above or in the default Oracle date format, without a time.

Note:

1. The FIXED_DATE parameter can be set in INIT.ORA or can be set dynamically using the command: ALTER SYSTEM SET FIXED_DATE = 'DD-MON-YY';

Unset FIXED_DATE by using the command: ALTER SYSTEM SET FIXED_DATE=NONE;

Once this command has been issued, SYSDATE will return to normal functionality.

2. 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) = ‘FIXED_DATE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
fixed_date		TRUE	FALSE	IMMEDIATE	TRUE	FALSE	fixed SYSDATE value

Oracle initializatoin parameters

FILESYSTEMIO_OPTIONS

Property	Description
Parameter type	String
Syntax	FILESYSTEMIO_OPTIONS = { none | setall | directIO | asynch }
Default value	There is no default value.
Modifiable	No
Basic	No

FILESYSTEMIO_OPTIONS specifies I/O operations for file system files.

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) = ‘FILESYSTEMIO_OPTIONS’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
filesystemio_options	asynch	TRUE	FALSE	FALSE	FALSE	FALSE	IO operations on filesystem files

Oracle initializatoin parameters

FILEIO_NETWORK_ADAPTERS

Property	Description
Parameter type	String
Syntax	FILEIO_NETWORK_ADAPTERS = adapter_name [, adapter_name ] ...
Default value	There is no default value.
Modifiable	No
Range of values	One or more network adapter names, separated by commas
Basic	No

FILEIO_NETWORK_ADAPTERS specifies a list of network adapters that can be used to access the disk storage. On platforms where the database files reside in network attached storage, this parameter provides the storage access library the list of network adapters that can be used to access the storage.

The netrwork adapter name is a fully qualified address name of the network card that can be accessed through the host name database or using the Network Information Service. The components of the adapter name are separated by periods. For example, the following is a fully qualified adapter name:

Note:

1. This parameter was introduced in 10g.

2. 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) = ‘FILEIO_NETWORK_ADAPTERS’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
fileio_network_adapters		TRUE	FALSE	FALSE	FALSE	FALSE	Network Adapters for File I/O

Oracle initializatoin parameters

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

FAST_START_PARALLEL_ROLLBACK

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
==================================================================

Property	Description
Parameter type	String
Syntax	FAST_START_PARALLEL_ROLLBACK = { HI | LO | FALSE }
Default value	LOW
Modifiable	ALTER SYSTEM
Basic	No

FAST_START_PARALLEL_ROLLBACK specifies the degree of parallelism used when recovering terminated transactions. Terminated transactions are transactions that are active before a system failure. If a system fails when there are uncommitted parallel DML or DDL transactions, then you can speed up transaction recovery during startup by using this parameter.
Values:

· FALSE

Parallel rollback is disabled

· LOW

Limits the maximum degree of parallelism to 2 * CPU_COUNT

· HIGH

Limits the maximum degree of parallelism to 4 * CPU_COUNT

If you change the value of this parameter, then transaction recovery will be stopped and restarted with the new implied degree of parallelisme.
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) = ‘FAST_START_PARALLEL_ROLLBACK’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
fast_start_parallel_rollback	LOW	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	max number of parallel recovery slaves that may be used

Oracle initializatoin parameters

FAST_START_MTTR_TARGET

Property	Description
Parameter type	Integer
Default value	0
Modifiable	ALTER SYSTEM
Range of values	0 to 3600 seconds
Basic	No
Real Application Clusters	Multiple instances can have different values, and you can change the values at runtime.

FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.

Note:

1. Related parameter: FAST_START_IO_TARGET, LOG_CHECKPOINT_INTERVAL

This parameter was introduced in Oracle9i. It replaces FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL in Oracle8i, although the old parameters can still be set if required in Oracle9i.

2. 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) = ‘FAST_START_MTTR_TARGET’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
dml_locks	11636	TRUE	FALSE	FALSE	FALSE	FALSE	dml locks - one for each table modified in a transaction

Oracle initializatoin parameters