How to diagnose performance problems using a COBOL SQL trace [Video] (Doc ID 1109345.1)

Last updated on NOVEMBER 10, 2016

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 CS Student Financials - 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

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