My Oracle Support Banner

ETL8.9 & 9.0: Performance Problem at TL_PUB_TM1.ACCT_DT.Step05 (SQL) (Doc ID 650024.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 8.9 and later
PeopleSoft Enterprise HCM Pay/Bill Management - Version 8.9 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201021698




Symptoms

Customer notices performance problem at TL_PUB_TM1.ACCT_DT.Step05 (SQL). Incident ID: 1368566000 was reported and resolved in Bundle #8. It reduced the number of joined tables from 4 to 3. Customer applied the fix but still notices performance issues. They added two update statistics steps before TL_PUB_TM1.ACCT_DT.Step05 for the table: TL_ACCTDT_WRK and WRK_PROJ2_TAO and noticed huge improvement. Performance went from 7 hours to 2 hours. App. Engine traces before and after the change are attached.

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
References

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