Solved

Different synchronization delay settings for individual Insert/Update/Delete operations?

Posted on 2016-11-03
7
32 Views
Last Modified: 2016-11-30
Does Oracle or AWS allow to configure separate propagation delays for insert/update/delete operations?
0
Comment
Question by:cyber-33
7 Comments
 
LVL 23

Expert Comment

by:David
Comment Utility
Not that I've ever heard of. Why would that be a good thing?
0
 
LVL 23

Expert Comment

by:David
Comment Utility
In the past, and I presume going forward, committing DML with the least delay has always been the strength of Oracle's two-phase transaction accuracy. Without knowledge of "upcoming features", then my answer is no.
0
 
LVL 4

Accepted Solution

by:
Abhimanyu Suri earned 500 total points
Comment Utility
I am assuming that you are talking about data replication here because you mentioned "propagation delays"

If so then yes it is possible but has a limited scope

For example : If source and target are Oracle and you are still using streams then set up a downstream environment. Replication will be archive based and that is all you going to get for lag. Please note that streams are not supported 11g onwards.

Set up data guard with ARCHIVE based service that again will give scope to introduce delays on the same ground.

If you are using a replication tool for example shareplex then stop the poster for designated time. This approach is little more configurable.

When it comes to Amazon , if using EC2 in my opinion all above should apply but if it is the case of RDS I am not sure if that would be possible.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>Please note that streams are not supported 11g onwards.

Incorrect.  It is still supported.  It has been deprecated in 12c but is still supported.
0
 
LVL 23

Expert Comment

by:David
Comment Utility
OTHO, cyber-33 did differentiate individual DML operations by their type. The insight about Streams is a good add, but my guess is the intent was to process inserts and deletes and updates at  different throughputs. <shrugs> We're going to have to wait on the author :)
0
 
LVL 4

Expert Comment

by:Abhimanyu Suri
Comment Utility
@Slightwv , Thanks for correction there.
0
 

Author Closing Comment

by:cyber-33
Comment Utility
Thank you
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

With the spotlight very much on Cloud technology within the IT industry, it’s difficult to avoid the topic these days. Due to the constant flood of new information, added pressure, emphasis and focus on cloud migration is driving corporations to inv…
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now