Oracle 参数 ADG_REDIRECT_DML 官方解释，作用，如何配置最优化建议
本站中文解释
_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 |
|
|
Modifiable |
Can be modified at the session level with a special |
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
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_DMLtotrue. -
To disable automatic redirection of DML operations to the primary at the system level, set
ADG_REDIRECT_DMLtofalse. -
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;
See Also:
Oracle Data Guard Concepts
and Administration for more information about automatic redirection of DML operations
