E-PN: What's The Purpose Of PSPTSVREVENTSUB Table?
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.
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