My Oracle Support Banner

Non integrated parallel replicat is slow due to buffer busy waits on checkpoint table (Doc ID 2920004.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Customer has implemented non-integrated parallel replicat and it is applying slow and accumulated  huge lag.

GGSCI (<host name>) 18> info <Replicat name>

REPLICAT <Replicat name> Last Started 2022-10-25 09:04 Status RUNNING
Parallel
Checkpoint Lag 39:38:11 (updated 00:00:01 ago)
Process ID 5310160
Log Read Checkpoint File <file name>
  2022-10-23 22:40:19.886315 RBA 936129110

Changes

 Implemented non-integrated parallel replicat.

APPLY_PARALLELISM setting is 64

Cause

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
Symptoms
Changes
Cause
Solution
References


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