R12: Performance Degrades with Deadlock Detected On ICX_Session_Attributes (Doc ID 1279850.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle CRM Technical Foundation - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On a 12.1.1 instance:
Performance degrades badly and alert log shows the following errors during the Performance problem:

DELETE FROM ICX_SESSION_ATTRIBUTES WHERE SESSION_ID = :B2 AND NAME= :B1
user session for deadlock lock 6a6000ff0

Changes

No changes Done.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms