My Oracle Support Banner

Intermittently LCR Propagation in a Streams environment does not restart when Latency > 0 (Doc ID 2026411.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.


Intermittently propagation of LCRs from one database to another stops and the propagation schedule has to be stopped and restarted in order for the LCRs to flow again and the latency of the schedules is > 0.

In addition to this the affected schedules have been created via the DBMS_PROPAGATION_ADM.CREATE_PROPAGATION api.

DBMS_AQADM.ALTER_PROPAGATION_SCHEDULE may have been used to alter the latency to 0 from the default value of 3 seconds in an attempt to resolve the issue.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.