11.5.10: Oracle iStore Credit Card Authorization Error: "Row Lock Contention"
(Doc ID 431084.1)
Last updated on MARCH 28, 2019
Applies to:Oracle iStore - Version 220.127.116.11 and later
Oracle Payments - Version 18.104.22.168 and later
Information in this document applies to any platform.
A 'row lock contention' error is seen in the database trace and noted poor performance when users are submitting credit card authorizations from iStore orders via iPayment.
The Database Trace/TKPROF output shows following statement as problem and wait details:
UPDATE IBY_SYS_SECURITY_SUBKEYS SET USE_COUNT = USE_COUNT + 1,
OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1, LAST_UPDATE_DATE =
SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID, LAST_UPDATE_LOGIN =
(SEC_SUBKEY_ID = :B1 )
WAIT #79: nam='enq: TX - row lock contention' ela= 488901 name|mode=1415053318 usn<
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