Blocking Session Causing Lock Waits In Production Database (Doc ID 2865963.1)

Last updated on SEPTEMBER 24, 2023

Applies to:

Symptoms

AWR revelead Waiting for event "enq: TX - row lock contention" in wait class for below SQL ID

UPDATE DLV_MESSAGE SET STATE = CASE WHEN ((RECOVER_COUNT >= (:1 -
:2 )) AND (:3 > :4 )) THEN :5 ELSE STATE END, RECOVER_COUNT =
(RECOVER_COUNT + :6 ) WHERE (((MESSAGE_GUID = :7 ) AND (STATE <> :8
)) AND (DLV_TYPE = :9 ))

Cause

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