Performance issue with COBOL (GL Consolidation)

user631175

Hi PeopleSoft experts -

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

Velu Angusamy

Hi - What cobol version you are using? Also issue only specific to this cobol or for all cobols?

-Velu

user631175

cobol v6.0.0

PRN=KXCRH/AAD:Ao.U4.13.04

PTI=32/64 bit

PTI=Micro Focus Visual COBOL Development Hub 6.0 - Patch Update 02

PTI=Patch Update 02

PTI=pkg_264847

PTI=MFInstaller