Oracle 参数 RECOVERY_PARALLELISM 官方解释，作用，如何配置最优化建议
本站中文解释
RECOVERY_PARALLELISM是一个可以减少数据库恢复时间的参数，当设置为1时，该参数表明数据库的恢复过程是单线程的；当设置值大于1时，表明数据库的恢复过程采用多线程的形式，可以加快恢复过程，但是注意，当你设置过大会降低效率，所以最好是以ORACLE建议的值为准。
正确设置：可以根据数据库环境和CPU数量，使用类似下面的语句设置RECOVERY_PARALLELISM：
ALTER SYSTEM SET RECOVERY_PARALLELISM = 5;
官方英文解释
RECOVERY_PARALLELISM specifies the number of processes to participate in instance or crash recovery.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
System-determined parallel recovery |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
System-determined, but cannot exceed |
|
Basic |
No |
To force serial crash and instance recovery, set the RECOVERY_PARALLELISM parameter to 0 or 1. 0 or 1 disable parallel instance and crash recovery on a system that has multiple CPUs. An alert log displays the degree of parallelism that was chosen when the database instance/recovery starts.
See Also:
-
Oracle Real Application
Clusters Administration and Deployment Guide for information on setting this parameter in an Oracle RAC environment
