Oracle 参数 RECOVERY

您所在的位置:网站首页 fgo中国翻译本子 Oracle 参数 RECOVERY

Oracle 参数 RECOVERY

2024-04-27 17:10| 来源: 网络整理| 查看: 265

本站中文解释

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