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

网络编程 Oracle 参数 ADG_REDIRECT_DML 官方解释，作用，如何配置最优化建议 10-15

本站中文解释

_MODE

ADG_REDIRECT_DML_MODE 参数控制Oracle golden gate 跨数据库 DML 同步时改写一致性事务的模式。

风格 1：使用原始的DML语句来重新定位更新操作。

风格 2：使用并标记的Join的查询更新操作。

正确的设置：

1.单机模式：在单个实例中，将ADG_REDIRECT_DML_MODE设置为0，使用原生SQL更新表。

2.数据库事务：如果您在分布式数据库环境中需要Oracle GoldenGate同步，将ADG_REDIRECT_DML_MODE设置为1，使用join查询更新表。

官方英文解释

Use ADG_REDIRECT_DML to enable or disable automatic redirection of DML operations from a standby to the primary in Oracle Active Data Guard environments.

Property	Description
Parameter type	Boolean
Default value	`false`
Modifiable	`ALTER SYSTEM` Can be modified at the session level with a special `ALTER` `SESSION` command. See details below.
Modifiable in a PDB	No
Range of values	`true \| false`
Basic	No
Oracle RAC	Different instances can use different values.

Automatic redirection of DML operations to the primary can be configured at the system level or the session level. The session level setting overrides the system level setting.

To enable automatic redirection of DML operations to the primary at the system level, set ADG_REDIRECT_DML to true.
To disable automatic redirection of DML operations to the primary at the system level, set ADG_REDIRECT_DML to false.
To enable automatic redirection of DML operations from a standby to the primary for the current session, issue the following SQL statement:
```
ALTER SESSION ENABLE ADG_REDIRECT_DML;
```
To disable automatic redirection of DML operations from a standby to the primary for the current session, issue the following SQL statement:
```
ALTER SESSION DISABLE ADG_REDIRECT_DML;
```

广州明生堂生物科技有限公司

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

本站中文解释

官方英文解释