Home » Server Options » Streams & AQ » streams
streams [message #573453] Fri, 28 December 2012 12:47 Go to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
I am trying oracle replication using streams
and quite easily successful too
I googled it alot but one doubt is that i fail to understand mechanism b/w the propagation stage to apply stage?
and what things we need to troubleshoot it?

Re: streams [message #573455 is a reply to message #573453] Fri, 28 December 2012 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Streams Concepts and Administration
Streams Advanced Queuing User's Guide and Reference

Regards
Michel


Re: streams [message #592190 is a reply to message #573455] Mon, 05 August 2013 09:28 Go to previous messageGo to next message
Isiss
Messages: 3
Registered: August 2013
Location: Albania
Junior Member
Hi,
I use Oracle change data capture to capture tha changes ,but recently I realized that the proccess apply approximatly 9 millions of changes.It is unusual couz I found that after un update the cdc apply them as changes,but in some of the cases the value is the same.How can avoid cdc to apply this updates as changes cous hey aren't changes?
Re: streams [message #592198 is a reply to message #592190] Mon, 05 August 2013 10:37 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
Can you avoid to update letting the same value?

Regards
Michel
Re: streams [message #592243 is a reply to message #592198] Tue, 06 August 2013 01:18 Go to previous messageGo to next message
Isiss
Messages: 3
Registered: August 2013
Location: Albania
Junior Member
I find no other explanation why the number of changes increases so much?
The purge job is acitvated and executed normally.Today it across 10 million.
Re: streams [message #592264 is a reply to message #592243] Tue, 06 August 2013 03:10 Go to previous message
Isiss
Messages: 3
Registered: August 2013
Location: Albania
Junior Member
I mean that after the changes have arrived in the staging database,
in the change tables there are rows of type UO and UN where actually there are no changes in the column values of the original tables.
It seems that an update has been executed in the production database that has not updated the original values or has updated them with the same values.
This is bringing a lot of change records where OLD and NEW are the same.
Is there any feature in the CDC that prevents this from happening in the moment when the changes are captured?
As of now I haven't yet identified what is the original update statement in production that is producing these rows.

Thank you
Previous Topic: About Replication
Next Topic: AQ wait time
Goto Forum:
  


Current Time: Sun Apr 20 20:22:22 CDT 2014

Total time taken to generate the page: 0.08258 seconds