Replicate hangs and TX - row lock contention in v$session

(Doc ID 1596884.1)

Last updated on FEBRUARY 07, 2018

Applies to:

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


 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


 No recent changes


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