Solved

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

Posted on 2016-11-03
7
94 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 23

Expert Comment

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

Expert Comment

by:David
ID: 41876227
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 5

Accepted Solution

by:
Abhimanyu Suri earned 500 total points
ID: 41876451
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
Will You Be GDPR Compliant by 5/28/2018?

GDPR? That's a regulation for the European Union. But, if you collect data from customers or employees within the EU, then you need to know about GDPR and make sure your organization is compliant by May 2018. Check out our preparation checklist to make sure you're on track today!

 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 41876484
>>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
ID: 41876527
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 5

Expert Comment

by:Abhimanyu Suri
ID: 41876538
@Slightwv , Thanks for correction there.
0
 

Author Closing Comment

by:cyber-33
ID: 41907642
Thank you
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle DB Slows After Datapump Until Next Reboot 27 171
how to double quote a string for an inline sql statement. 8 125
oracle forms question 22 61
plsql job on oracle 18 109
AWS has developed and created its highly available global infrastructure allowing users to deploy and manage their estates all across the world through the use of the following geographical components   RegionsAvailability ZonesEdge Locations  Wh…
If you are thinking of adopting cloud services, or just curious as to what ‘the cloud’ can offer then the leader according to Gartner for Infrastructure as a Service (IaaS) is Amazon Web Services (AWS).  When I started using AWS I was completely new…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

738 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