Skip to main content

this is a COBOL performance issue related to PeopleSoft.  We are doing a system upgrade and having no change in COBOL program.  We are seeing our cobol process running much slower.  Available tracing shows us the issue is not SQL performance related. 

We are upgrading from PT 8.56 to PT 8.59 and Oracle DB 12c Extreme Performance RAC to DB 21c Extreme Performance RAC. New and Old environments are all in OCI.

Our issue is that existing COBOL program for GL Consolidation is running much slower on the PT 8.59 environment. We have worked with Oracle Support and provided AWR reports and can confirm the issue is not SQL or DB tuning related.

In the COBOL trace we see that total time in application is greatly increased in our new environment compared to old. Process is running more than twice as long in new environment on equivalent linux process schedulers with same ocpu/memory etc.

Any idea what influences the Total in Application time?

Also - we have tried recompiling cobol and even creating entire new process scheduler server and see no improvement.

                                   Time  % Total
Total in SQL:                    235.12    21.58
Total in Application:            854.19    78.42
                              ---------
Total Run Time:                 1089.31


Total Statements:               142
Max Cursors Connected:           46

this is a COBOL performance issue related to PeopleSoft.  We are doing a system upgrade and having no change in COBOL program.  We are seeing our cobol process running much slower.  Available tracing shows us the issue is not SQL performance related. 

We are upgrading from PT 8.56 to PT 8.59 and Oracle DB 12c Extreme Performance RAC to DB 21c Extreme Performance RAC. New and Old environments are all in OCI.

Our issue is that existing COBOL program for GL Consolidation is running much slower on the PT 8.59 environment. We have worked with Oracle Support and provided AWR reports and can confirm the issue is not SQL or DB tuning related.

In the COBOL trace we see that total time in application is greatly increased in our new environment compared to old. Process is running more than twice as long in new environment on equivalent linux process schedulers with same ocpu/memory etc.

Any idea what influences the Total in Application time?

Also - we have tried recompiling cobol and even creating entire new process scheduler server and see no improvement.

                                   Time  % Total
Total in SQL:                    235.12    21.58
Total in Application:            854.19    78.42
                              ---------
Total Run Time:                 1089.31


Total Statements:               142
Max Cursors Connected:           46

Hello Glenn,

 

Welcome to the Micro Focus Community Site. I'm sorry to hear about the performance issue you're hitting. Can you provide more detail about the nature of the system upgrade you mentioned?

It sounds like you are running a newer version of the Oracle PeopleTools product, but has anything else changed? You mentioned that there was no change in the COBOL programs, but are there differences in the O/S version, file storage, networking, COBOL product version? Also, what is the Linux version in use, and which COBOL product and version are you using in the old and new environments?

Terms & ConditionsAccessibility statement