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

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