1.9 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 |
|
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_DML
totrue
. -
To disable automatic redirection of DML operations to the primary at the system level, set
ADG_REDIRECT_DML
tofalse
. -
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
Note:
This parameter is available starting with Oracle Database release 19c, version 19.1.