Performance Issue PRC:Update Project Summary Amounts, Taking Over 5 Hours To Complete. (Doc ID 2287187.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Symptoms

PRC: Update Project Summary Amounts,
New performance issue after application of <patch:25291535> for <bug 24580649>

DELETE PA_TXN_ACCUM_DETAILS PTAD
WHERE
 TXN_ACCUM_ID IN (SELECT TXN_ACCUM_ID FROM PA_TXN_ACCUM PTA WHERE
  PTA.PROJECT_ID = :B3 AND NVL(PTA.SYSTEM_LINKAGE_FUNCTION,'X') = NVL(NVL(:B2
  ,PTA.SYSTEM_LINKAGE_FUNCTION),'X') AND EXISTS ( SELECT 'Yes' FROM
  PA_PERIODS WHERE PERIOD_NAME = PTA.PA_PERIOD AND START_DATE >= :B5 AND
  END_DATE <= :B4 ) ) AND PTAD.LINE_TYPE = 'M' AND ROWNUM <= :B1


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 175 16489.33 37063.87 3557341 917957773 331599 29618
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 176 16489.33 37063.87 3557341 917957773 331599 29618

Cause

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