My Oracle Support Banner

Wait Time for 'enq: TX - row lock contention' During Deadlock Is Always Multiple Of 3 Seconds (Doc ID 2530567.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

During the deadlock detection (ORA-00060), there seems to be a common pattern for the wait time of 'enq: TX - row lock contention' which always reported in multiple of 3 seconds.

Example from the deadlock trace file:

Refer to "wait times:" under "Current Wait Stack:"

Current Wait Stack:
  0: waiting for 'enq: TX - row lock contention'
  name|mode=0x54580006, usn<  wait_id=947 seq_num=948 snap_id=1
  wait times: snap=3.000614 sec, exc=3.000614 sec, total=3.000614 sec
  wait times: max=infinite, heur=3.000614 sec
  wait counts: calls=1 os=1
  in_wait=1 iflags=0x15a0
  There is at least one session blocking this session.
 

 

Solution

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
Goal
Solution


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