My Oracle Support Banner

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.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.