H,

I could see there are DB alerts on PR SYS LOCKS table and since this is an OOTB table any know issues or hotfix available.

I know that Lock management is controlled through the database table PR_SYS_LOCKS and because of the high volume of entries inserted into and deleted from this table during case processing, the data in the PR_SYS_LOCKS table.

Slow SQL on table PEGADATA.PR_SYS_LOCKS

INSERT INTO pegadata.pr_sys_locks (pxCreateDateTime, pxCreateOpName, pxCreateOperator, pxCreateSystemID, pxExpireDateTime, pxLockHandle, pxObjClass, pxOwnerId, pxSystemName, pxSystemNode, pxUpdateDateTime, pxUpdateOpName, pxUpdateOperator, pxUpdateSystemID, pxUserHost, pyLabel, pzInsKey) VALUES (?, ?, ?, ?, ?, ?, 'literal', ?, ?, ?, ?, ?, ?, ?, ?, 'literal', ?)

DELETE FROM pegadata.pr_sys_locks WHERE pxOwnerId = ?

Regards