• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

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

Does Oracle or AWS allow to configure separate propagation delays for insert/update/delete operations?
1 Solution
DavidSenior Oracle Database AdministratorCommented:
Not that I've ever heard of. Why would that be a good thing?
DavidSenior Oracle Database AdministratorCommented:
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.
Abhimanyu SuriSr Database EngineerCommented:
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.
Firewall Management 201 with Professor Wool

In this whiteboard video, Professor Wool highlights the challenges, benefits and trade-offs of utilizing zero-touch automation for security policy change management. Watch and Learn!

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

Incorrect.  It is still supported.  It has been deprecated in 12c but is still supported.
DavidSenior Oracle Database AdministratorCommented:
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 :)
Abhimanyu SuriSr Database EngineerCommented:
@Slightwv , Thanks for correction there.
cyber-33Author Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Increase Security & Decrease Risk with NSPM Tools

Analyst firm, Enterprise Management Associates (EMA) reveals significant benefits to enterprises when using Network Security Policy Management (NSPM) solutions, while organizations without, experienced issues including non standard security policies and failed cloud migrations

Tackle projects and never again get stuck behind a technical roadblock.
Join Now