PERFORMANCE ISSUE - PRC: UPDATE PROJECT SUMMARY AMOUNTS (Doc ID 2063959.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms



Performance issue when running PRC: UPDATE PROJECT SUMMARY AMOUNTS

INSERT INTO PA_PROJECTS_FOR_ACCUM (PROJECT_ID, REQUEST_ID, ACTION_FLAG,
  SEGMENT1, EXCEPTION_FLAG) SELECT :B1 , :B3 , 'CM', :B2 , 'N' FROM DUAL
  WHERE PA_CHECK_COMMITMENTS.COMMITMENTS_CHANGED(:B1 ) = 'Y'


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 29168 166.95 4894.72 440853 2472732 7148 1631
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 29169 166.95 4894.72 440853 2472732 7148 1631

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