Oracle教程 2023-04-02

Oracle 参数 INMEMORY_ADG_ENABLED 官方解释，作用，如何配置最优化建议

本站中文解释

INMEMORY_ADG_ENABLED参数用于控制In-Memory Advisors Data Grid (ADG)特性的启用或禁用，该参数为布尔型参数，有两种配置值：
true: In-Memory ADGrid启用。
false: In-Memory ADGrid禁用。

一般来说，当希望在数据库内使用In-Memory ADGrid时，可以将INMEMORY_ADG_ENABLED参数设置为true，从而提高数据库的性能，这也是默认设置。

为了正确设置INMEMORY_ADG_ENABLED参数，只需要使用如下SQL脚本：

ALTER SYSTEM SET INMEMORY_ADG_ENABLED=true SCOPE=SPFILE;

此时，Oracle数据库会以变量INMEMORY_ADG_ENABLED=true的形式将该参数加载到spfile.ora文件中。接下来，只需要重启数据库即可，这样便可以完成In-Memory ADGrid的正确设置。

官方英文解释

INMEMORY_ADG_ENABLED indicates whether in-memory for Active Data Guard is enabled in addition to the in-memory cache size.

Property	Description
Parameter type	Boolean
Default value	`true`
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	No
Range of values	`true \| false`
Basic	No
Oracle RAC	The same value should be used on all instances. If the value for this parameter is changed on one instance, the parameter’s value should be changed to the same value on the other instances.

For Active Data Guard, media recovery needs to retrieve in-memory objects when applying redo and to invalidate the related objects after the query advance. This parameter controls whether media recovery does the retrieving and invalidating.

This parameter should be set on standby databases. The value of this parameter is meaningless on a primary database.

If the standby is an Oracle RAC instance, then all the different standby instances must have this parameter set to the same value.

This parameter is a dynamic system-modifiable parameter whose value can be changed only when Active Data Guard recovery is not running.

If you start multi-instance redo apply (MIRA) Active Data Guard recovery, all instances involved in MIRA must have the parameter set to the same value, otherwise MIRA will signal an error.

Example

If the standby is an Oracle RAC instance, this parameter should be set to the same value on all the Oracle RAC instances:

SQL> alter system set inmemory_adg_enabled=true sid='*';

本站中文解释

官方英文解释

相关推荐