PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Interesting Discovery about PeopleCode Memory Management

We are running PeopleTools 8.54.

I developed an AE PeopleCode program to retrieve a list of employees, and for each employee, to load the employee's JOB records into a record array, before doing other processing. We found that the program took 12 hours to process about 27,000 employees. We also noticed that the processing time per employee (as measured by the interval produced by the WriteToLog Statement) got steadily longer as the program ran. It started at 0.003 seconds per employee, and after the first thousand employees it was almost ten times that amount. Our DBA checked the SQL and found nothing wrong, but noticed

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