PSLOCKS WHEN RUNNING SEARCH/MATCH/POST (SCC_SL_SMP) And Slowing Performance (Doc ID 2270396.1)

Last updated on MAY 25, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.

Goal

On :  Campus Solutions 9.2, PSLOCK is occurring when running Search/Match/Post (SCC_SL_SMP) process.
PSLOCK issue seems to be stemming from the 'save' call in app class SCC_SL_TRANSACTION:ACCESSORS:StagedUserPerzCategory, which is issuing:
SQLExec("DELETE FROM PSUSERPRSNLOPTN WHERE OPRID = :1 and
OPTN_CATEGORY_LVL=:2 and USEROPTN=:3", &userid, %This.OPTN_CATEGORY_LVL,
%This.USEROPTN);

This table is a tools table, and tools internally serializes its updates via
the PSLOCK table using object type names = 'UPM' and 'SYS'.
Although PSLOCK is being updated when the rowsetcache objects are being
refreshed, this only happens the first time they are used. After that, they
stay in the rowset cache, and this does not trigger updates to PSLOCK.

Solution

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