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