E-IB: Deadlocking in PSIBQUEUEINST
(Doc ID 656090.1)
Last updated on AUGUST 13, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201047197
***Checked for relevance on 08-SEP-2017***
When submitting messages on Tools 8.48 we are seeing Deadlocking in PSIBQUEUEINST.
During stress testing we found deadlocking in the PSIBQUEUEINST table like the following
17.24.48 11446.608369 SQL error. Stmt #: 337 Error Position: 0 Return: 60 - ORA-00060: deadlock detected while waiting for resource
17.24.48 0.000088 Sam SqlError: UPDATE PSIBQUEUEINST SET QUEUESEQID=QUEUESEQID+:1 WHERE QUEUENAME=:2
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