Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to identify broken stream replication

LinoPistoNov 30 2017 — edited Dec 1 2017

Hello

My bidirectional replication container works perfectly for every table except one (it was working before).

Looking at the oracle documentation, for my db 11.2 is apparently easy to identify the latency
https://docs.oracle.com/cd/E11882_01/server.112/e17069/strms_apmon.htm#STRMS962

Example V$STREAMS_APPLY_COORDINATOR Query for Latency

The result of the query says I have 2 seconds of delay, but is not true, it is much more.

Please can somebody tell me how to identify and fix this problem.

Even simple identification would be a great step for me.

Thanks,

Massimo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2017
Added on Nov 30 2017
2 comments
326 views