My Oracle Support Banner

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.

Goal

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.

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.