My Oracle Support Banner

OGG SQL Server Replicat Blocking Sessions With "begin Transaction ggs_repl" (Doc ID 2376850.1)

Last updated on OCTOBER 31, 2019

Applies to:

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

Symptoms

Oracle GoldenGate Delivery for SQL Server
     Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419
Windows x64 (optimized), Microsoft SQL Server on Jun 30 2017 10:25:33

OGG Replicat applies the records on target with Transaction boundaries using "begin Transaction ggs_repl"

On rare cases locks are seen on objects due to this.

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


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