Replicate hangs and TX - row lock contention in v$session (Doc ID 1596884.1)

Last updated on NOVEMBER 18, 2016

Applies to:

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

Symptoms

 Replicate process hangs. The query to v$session shows transaction locks on the replicate session. Example as seen on session waits are

 

SID EVENT                                    PROGRAM                                          MODULE                                           SQL_HASH_VALUE LAST_CALL_ET
---------- ---------------------------------------- ------------------------------------------------
      513 enq: TX - row lock contention            replicat@dalccadb01 (TNS V1-V3)                  replicat@dalccadb
      523 SQL*Net message from client              replicat@dalccadb01 (TNS V1-V3)                  replicat@dalccadb0
      542 SQL*Net message from client              replicat@dalccadb01 (TNS V1-V3)                  replicat@dalccadb0

 

Restarting the replicate will not help and the tx locks are observed even after a restart.

Killing the session does not help. After replicate restart, the locks are still present

Changes

 No recent changes

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms