My Oracle Support Banner

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 11.5.10.0 and later
Oracle Payments - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

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 =
FND_GLOBAL.LOGIN_ID
WHERE
(SEC_SUBKEY_ID = :B1 )

WAIT #79: nam='enq: TX - row lock contention' ela= 488901 name|mode=1415053318 usn<

Cause

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
Symptoms
Cause
Solution
References

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