How to diagnose performance problems using a COBOL SQL trace [Video]
(Doc ID 1109345.1)
Last updated on OCTOBER 20, 2020
Applies to:PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 and later
PeopleSoft Enterprise CS Campus Community - Version 9 and later
PeopleSoft Enterprise CS Student Records - Version 8.9 and later
PeopleSoft Enterprise PT PeopleTools - Version 8.40 and later
PeopleSoft Enterprise HCM Payroll for North America - Version 8.9 and later
Information in this document applies to any platform.
When you encounter a performance problem with a single COBOL job, when other COBOL jobs are working fine, you will need to identify poorly performing SQL statements used by that job so that you can tune the statement, indices or database to meet the needs of the job.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!