OraFAQ Forum: Streams & AQ

Home » Server Options » Streams & AQ » streams

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

streams [message #573453]

Fri, 28 December 2012 12:47

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?

Report message to a moderator

Re: streams [message #573455 is a reply to message #573453]

Fri, 28 December 2012 12:55

Michel Cadot
Messages: 68345
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

Report message to a moderator

Re: streams [message #592190 is a reply to message #573455]

Mon, 05 August 2013 09:28

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?

Report message to a moderator

Re: streams [message #592198 is a reply to message #592190]

Mon, 05 August 2013 10:37

Michel Cadot
Messages: 68345
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No.
Can you avoid to update letting the same value?

Regards
Michel

Report message to a moderator

Re: streams [message #592243 is a reply to message #592198]

Tue, 06 August 2013 01:18

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.

Report message to a moderator

Re: streams [message #592264 is a reply to message #592243]

Tue, 06 August 2013 03:10

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

Report message to a moderator

Previous Topic:	About Replication
Next Topic:	AQ wait time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 03 03:12:35 CST 2023