Performance issue with COBOL (GL Consolidation)
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.