ETL8.x : Performance issue/TL LOAD insert to PS_PY_PYBL_TM_WRK
(Doc ID 660708.1)
Last updated on DECEMBER 10, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document