My Oracle Support Banner

E-IB: Integration Broker Performance Downgraded because of Locks On Table PSIBQUEUEINST and PSAPMSGPUBSYNC (Doc ID 1367618.1)

Last updated on MARCH 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.
*************Checked currency at <>*****************************
*****************************************
Checked currency at <<14/05/2013>>
****************************************

Symptoms

There are locks on the below two Integration Broker tables that are causing significant performance loss.

PSIBQUEUEINST
PSAPMSGPUBSYNC


The database locks view shows two related update statements:UPDATE PSIBQUEUEINST SET QUEUESEQID=QUEUESEQID+:1 WHERE QUEUENAME=:2

UPDATE PSAPMSGPUBSYNC SET LASTUPDDTTM=SYSDATE WHERE QUEUENAME=:1


There should be no long running locks on any database tables for the performance to be at its best.

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!


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