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