ETL8.x : Performance issue/TL LOAD insert to PS_PY_PYBL_TM_WRK
Last updated on JULY 13, 2016
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 8 and later
PeopleSoft Enterprise HCM Pay/Bill Management - Version 8.9 and later
Information in this document applies to any platform.
SPECIFIC TO: Enterprise Time and Labor Release 8.x and potentially 9.x as well
This document was previously published as Customer Connection Solution 201064340
Customer is on ORACLE 10.2.02 RELEASE, and have serious performance issues with the TL Load process. Customer felt that the process is running into contention when Load is running at the same time as another process accessing the same tables. The DB waits on the tables are slowing down the application processes. It used to take 2 hrs for TL Load, now 4 hours. The process scheduler PSUNX is installed on the database server. Memory Utilization is maxed at 99% with minimal processes running during the TL LOAD to paysheet process. Currently the server memory is 24gb.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms