Has anyone encountered locking issues on any application tables after upgrading to PeopleTools 8.60.05? We started noticing session locking on several tables (PSVERSION, TUIT_CALC_TBL, PS_LAST_3CS_TBL, ETC…) within our Campus solution application. The lock doesn't release the session on time and we have to manually monitor and kill the sessions. It gets to a point where we are monitoring the lock for several hours just to see how long the sessions remain locked. This behavior wasn't there in our previous 8.58.15 Tools version, It would release the lock on time and process anything on the queue. So I'm curious to know if anyone else is having this problem, keep in mind we have around 500 active users on the system every minute or so and have several Batch jobs running on a recurrence.
We are on PUM28
PeopleTools 8.60.05
Oracle Linux 7
Oracle 19c