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

Last updated on JULY 17, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PRC: Update Project Summary Amounts,
New performance issue after application of 1-off 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

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