E-IB: Integration Broker Performance Downgraded because of Locks On Table PSIBQUEUEINST and PSAPMSGPUBSYNC
(Doc ID 1367618.1)
Last updated on DECEMBER 03, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.
There are locks on the two Integration Broker tables bekiw that are causing significant performance loss.
The database locks view shows two related update statements:UPDATE PSIBQUEUEINST SET QUEUESEQID=QUEUESEQID+:1 WHERE QUEUENAME=:2
There should be no long running locks on any database tables for the performance to be at its best.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!