E-PN: What's The Purpose Of PSPTSVREVENTSUB Table?
(Doc ID 2393194.1)
Last updated on APRIL 30, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.
Customer was experiencing a number of deadlocks on their database, while researching this they found multiple occurrences of the following statement:
DELETE FROM PSPTSVREVENTSUB
They worked with the Integration team to resolve the deadlocks by moving their tablespace. But they are wanting more information on the above statement, what it is doing and why it does not include a 'where' clause.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!