PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

General Tuning for Unarchived Data

We're currently on PeopleTools 8.53 and applications 9.1, but will be upgrading to the latest versions this summer.

We've noticed that in a lot of areas where there's large amounts of data (e.g., PeopleSoft HR, Review Employee Self Service Paycheck) transactions begin to time out (e.g., trying to access an employee with 400+ checks.

While the best solution is to archive the data, is there an interim solution or anything that can be done to tune/throw hardware at the problem? Is there something that can be done configuring the application server?

I don't think it's a database issue, since performing similar raw queries w/ a SQL tool return the data pretty quickly.

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