ETL9.1: Timesheet Performance and DB contention issue.
Last updated on DECEMBER 14, 2017
Applies to:PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***
On : 9.1 version, Time and Labor performance issue.
Users are taking 5 to 15 mins to login to the application, and also long times are being seen when trying to report time.
Expected that the users should be able to login and open timesheet in few secs.
1. Busy days when all users are entering their time.
2. As the employees and managers are reporting time and approving time they are seeing table locks occurring and slowness as more users attempt to login.
3. AWR report showing 88% of the total elapse time taken on
UPDATE PS_EOAW_IDS SET EOAWCOUNTER = EOAWCOUNTER + 10 WHERE EOAWCOUNTERNAME = 'TL_APP_RPTD_XRF'
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