My Oracle Support Banner

GoldenGate Integrated REPLICAT appears to be hung: BATCHSQL with large "apply shared t" in the Streams Pool (Doc ID 1985152.1)

Last updated on JANUARY 30, 2020

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 to 12.1.3.0.0 [Release 11.1.1 to 12.1]
Information in this document applies to any platform.

Symptoms

An Integrated REPLICAT appears to be consuming a lot of memory in the Oracle database Streams Pool, where it is processing in the order of 50 million operations per day.
However, it also appears to be hung, or slow.
On examination:

Changes

The REPLICAT has been configured with the BATCHSQL parameter

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.