PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

GPPDPRUN Payroll Calculation Performance Issue

edited Oct 5, 2012 7:38AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 15 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center