Friday, February 13, 2009

RECOVERY_PARALLELISM

Property

Description

Parameter type

Integer

Default value

Operating system-dependent

Modifiable

No

Range of values

Operating system-dependent, but cannot exceed PARALLEL_MAX_SERVERS

RECOVERY_PARALLELISM specifies the number of processes to participate in instance or crash recovery. A value of 0 or 1 indicates that recovery is to be performed serially by one process.

Note:

1. See also

  • Oracle Database Performance Tuning Guide for information on setting this parameter in exclusive mode
  • Oracle Real Application Clusters Administration and Deployment Guide for information on setting this parameter in a Real Application Clusters environment

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) = 'RECOVERY_PARALLELISM';

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

recovery_parallelism

0

TRUE

FALSE

FALSE

FALSE

FALSE

number of server processes to use for parallel recovery

Oracle initializatoin parameters

No comments:

Post a Comment