Contention On soaqtz_LOCKS Table
(Doc ID 1336419.1)
Last updated on MARCH 27, 2020
Applies to:
Oracle SOA Suite - Version 11.1.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
Contention around the soaqtz_LOCKS table causes transaction timeouts and degrades performance.
Long running SQL statement indicative of this issue:
UPDATE soaqtz_LOCKS SET LOCK_NAME = LOCK_NAME WHERE LOCK_NAME = :1
Changes
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 |
Changes |
Cause |
Solution |
References |