SESSION IS WAITIING ON ROW BUT THE ROW IS UPDATABLE BY OTHER SESSIONS
(Doc ID 749395.1)
Last updated on JUNE 24, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
In some cases , one or more sessions are waiting for TX-enqueue mode=X when trying to update row1 in a table. The blocking session is holding the TX-enqueue in mode X, while row1 is not actually locked by the blocker. Other sessions can update the row and commit/rollback without problems.
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