ADG_REDIRECT_DML

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	Yes This parameter is modifiable in a PDB starting with Oracle AI Database 26ai, Release Update 23.26.2.
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;
```

See Also: Oracle Data Guard Concepts and Administration for more information about automatic redirection of DML operations