ETL8.x : Performance issue/TL LOAD insert to PS_PY_PYBL_TM_WRK (Doc ID 660708.1)

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




Symptoms

 
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.  

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms