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 | |
No comments:
Post a Comment