My Oracle Support Banner

Integrated Extract Hangs For 10 Minutes Every Day Due To dbms_capture_adm_internal.enforce_checkpoint_retention() Execution (Doc ID 2519583.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

On : 12.2.0.1.0 version, 1 - Oracle DB backend


We noticed that our Goldengate replication is hanging every day for 10 minutes.
It caused by long execution of dbms_capture_adm_internal.enforce_checkpoint_retention(:1, :2, :3); END;

Changes

 

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.