Oracle 19c: ADG DML Redirect

-























Oracle 19c New Features



Oracle MAA

























11g Snapshot Standby



12c ADG Far Sync
No database files, only redo logs and control files. No recovery needed.
Using Data guard broker to control and switch























18c enhancement























19c ADG New Features






alter session enable adg_rediect_dml;
 























In Summary


--End of File--

Comments

Post a Comment

Popular posts from this blog

SQL Monitor and SQL Quarantine

-
SQL Monitor belongs Oracle Tuning Pack STATISTICS_LEVEL=TYPICAL(default) or all, will start QAL monitor features. Events to Trigger SQL monitor           单次执行消耗大于等于5秒cpu/IO时间的SQL PL/SQL           并行执行的语句           加/* + MONITOR*/ hint的SQL语句           用sql_monitor事件指定SQL ID对应的SQL                alter system set events 'sql_monitor [sql:5hc07qvt8v737 | sql:9ht3ba3arrzt3] force=true           利用存储过程          DBMS_SQL_MONITOR.BEGNIS_OPERATION and DBMS_SQL_MONITOR.END_OPERATION 定义的会话中的所有SQL PL/SQL CONTROL_MANAGEMENT_PACK_ACCESS is the default Oracle parameter. Set the default parameter: Diagnostic + Tuning.          CONTROL_MANAGEMENT_PACK_ACCESS SQL监控方法          cloud control          sql develo...
Read more