How to diagnose performance problems using a COBOL SQL trace [Video]
(Doc ID 1109345.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 and laterPeopleSoft 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.
Goal
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.
This article applies to any Peoplesoft application that uses COBOL processes.
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! |