GPPDPRUN Payroll Calculation Performance Issue
I already migrated from Solaris to HP-UX and from 9i to 11.2.0.3.0. The problem that we are having is that the time of calculation of some paygroups increase a lot of time, ( about 1hr more, and the new hardware on HP-UX is most powerfull - CPU and Memory - ). I already identified the Cobol and SQL with the issue: GPPIDNT1_I_HSTREG ( this is the only SQL sentence that run very slow, now: 4065 seconds and on the old server it run in only 97 seconds. ). We begin to update statics whit the oracle info:
- How to Manage CBO Statistics During an Upgrade from 10g or 9i into 11g ID 465787.1
- How to Manage CBO Statistics During an Upgrade from 10g or 9i into 11g ID 465787.1
2