Oracle 参数 RECOVERY |
您所在的位置:网站首页 › fgo中国翻译本子 › Oracle 参数 RECOVERY |
本站中文解释
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 ALTER SYSTEM Modifiable in a PDB No Range of values System-determined, but cannot exceed PARALLEL_MAX_SERVERS initialization parameter setting 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
|
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |