In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Adg_redirect_dml of the new features of Oracle 19c ADG
SQL*Plus: Release 19.0.0.0.0-Production on Thu Nov 28 11:35:05 2019Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0-ProductionVersion 19.3.0.0.0SQL > set lines 120SQL > show parameter adg_redirect_dml NAME TYPE VALUE-- adg_ Redirect_dml boolean FALSEADG_REDIRECT_DML enables DML redirection from Oracle Active Data Guard. Configuring automatic redirection DML operations supports both the session level and the system level, which overrides the system level configuration. Enable DML redirection on all slave libraries to set the initialization parameter ADG_REDIRECT_DML to trueALTER SYSTEM SET ADG_REDIRECT_DML=true SCOPE=BOTH; current session enable DML redirection ALTER SESSION ENABLE ADG_REDIRECT_DML
The default value of this parameter is false, which only started in the version of Oracle 19c. The main function is that when we perform DML operations in the slave database, it will be redirected to the master database, and then synchronize to the slave database in the master database. We didn't turn it on by default.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.