Oracle 19c ADG新特性之adg_redirect_dml

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 28 11:35:05 2019
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> set lines 120
SQL> show parameter adg_redirect_dml;

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
adg_redirect_dml                     boolean                FALSE


ADG_REDIRECT_DML enables DML redirection from Oracle Active Data Guard.

![](https://s1.51cto.com/images/blog/201911/28/16043160133cdefc7bf51c59745ca705.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_30,g_se,x_10,y_10,shadow_20,type_ZmFuZ3poZW5naGVpdGk=)