My Oracle Support Banner

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




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

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
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.