GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Delay after entering DataSource::readLCR()

Hi there,

OGG Version Version 19.1.0.0.4. Oracle DB 19c. Linux operating system.

We have an average latency of 5 seconds in replicating from SOURCE to TARGET DB, using OGG.

Enabling trace, there looks to be a delay between the 2 highlighted log lines:



06:06:29.690 (94465) * --- entering DataSource::readLCR() --- *
06:06:31.503 (96278) Extract pointer info reused [0], [file 0][src 0][tgt 0][tab X.TABLE1]. File [X.TABLE1], targ_idx [4294967295], object type [2], num_extracts [1]
06:06:31.503 (96278) exited DataSource::readLCR(stat=0,io_type=5)
06:06:31.503 (96278) processing record for TMS.IDENTIFIER_TOKEN_TBL
06:06:31.503 (96278) Writing seqno [227], rba [1278], table [X.TABLE1]
06:06:31.503 (96278) * --- entering DataSource::readLCR() --- *
06:06:32.425 (97200) Extract pointer info reused [0], [file 0][src 0][tgt 1][tab X.TABLE2
]. File [X.TABLE2], targ_idx [4294967295], object type [2], num_extracts [1]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center