High Number Of "enq: TX - Row Lock Contention" On FND_USER_PREFERENCES
(Doc ID 2578726.1)
Last updated on AUGUST 07, 2021
Applies to:Oracle E-Business Suite Performance - Version 12.2.7 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.
High number of "enq: TX - row lock contention" on FND_USER_PREFERENCES table
Running E-Business Suite 12.2.7 and recently upgraded from earlier version,experiencing lots of wait events on the FND_USER_PREFERENCES table.
This contention appears at anytime.
AWR Report below SQL
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