ETL9.2: Performance Problem In TL_TA001000.DD000. Step013 (Doc ID 2649516.1)

Last updated on MAY 05, 2020

Applies to:

Symptoms

TimeAdmin slow performance in TL_TA001000.DD000.STEP013 after PUM31.

Timeadmin AWR report is showing the longest elapsed time of 957.36 in the following SQLs:

DELETE FROM PS_EOAW_WL WHERE EOAWTHREAD_ID IN ( SELECT D.EOAWPARENT_THREAD
FROM PS_TL_APP_TMP12 T , PS_TL_APP_PAY_XRF X , PS_EOAW_SUMM_DTL D WHERE
T.PROCESS_INSTANCE = :"SYS_B_0" AND T.EMPLID = X.EMPLID AND T.EMPL_RCD =
X.EMPL_RCD AND T.SEQ_NBR = X.SEQ_NBR AND D.EOAWTHREAD_ID = X.EOAWTHREAD_ID
AND D.EOAWPRCS_ID = X.EOAWPRCS_ID AND D.EOAWPRCS_ID = PS_EOAW_WL.EOAWPRCS_ID)
AND BUSPROCNAME = :"SYS_B_1" AND ACTIVITYNAME = :"SYS_B_2" AND EVENTNAME IN
(:"SYS_B_3", :"SYS_B_4") AND EOAWPRCS_ID = :"SYS_B_5"

 EOAWTHREAD_ID IN ( SELECT D.EOAWPARENT_THREAD
FROM PS_TL_APP_TMP12 T , PS_TL_APP_PAY_XRF X , PS_EOAW_SUMM_DTL D WHERE
T.PROCESS_INSTANCE = :"SYS_B_0" AND T.EMPLID = X.EMPLID AND T.EMPL_RCD =
X.EMPL_RCD AND T.SEQ_NBR = X.SEQ_NBR AND D.EOAWTHREAD_ID = X.EOAWTHREAD_ID
AND D.EOAWPRCS_ID = X.EOAWPRCS_ID AND D.EOAWPRCS_ID = PS_EOAW_WL.EOAWPRCS_ID)
AND BUSPROCNAME = :"SYS_B_1" AND ACTIVITYNAME = :"SYS_B_2" AND EVENTNAME IN
(:"SYS_B_3", :"SYS_B_4") AND EOAWPRCS_ID = :"SYS_B_5"

STEPS:
1. Run TA process for 3 employees.

Changes

Cause

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