XStream Capture required_checkpoint_scn does not change over time
Last updated on APRIL 24, 2014
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 to 184.108.40.206 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Customer has a XStreams XOut configuration in a single instance 220.127.116.11 database.
The required_checkpoint_scn of the XStreams Capture process is not changing over time, despite the Capture progressing.
Long running open transactions which never end are observed in the Streams healthcheck report under the section
++ OPEN STREAMS APPLY TRANSACTIONS ++
The transactions are for DDL associated with analyze statements which the XStream Capture is not interested in which indicates that this is a different issue to that discussed in <Note 1412928.1>.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms