18713129: Performance Issue With Compile Burden Schedule Revisions (Doc ID 2018520.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Project Costing - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.6 version, Burdening

ACTUAL BEHAVIOR
---------------
PRC: Compile All Burden Schedule Revisions won't complete. During testing the process ran for 13 days before it was finally cancelled.

 

The following queries are the lowest performing queries taken from the trace
file:

SQL ID: 7pwpbczrcz4dr
Plan Hash: 643326358
SELECT 1
FROM
SYS.DUAL WHERE EXISTS(SELECT 1 FROM PA_IND_COST_MULTIPLIERS ICM ,
PA_IND_COMPILED_SETS ICS WHERE ICM.IND_RATE_SCH_REVISION_ID =
ICS.IND_RATE_SCH_REVISION_ID AND ICM.IND_RATE_SCH_REVISION_ID = :B4 AND
ICM.ORGANIZATION_ID =ICS.ORGANIZATION_ID AND ICM.ORGANIZATION_ID = :B3 AND
ICS.COST_BASE = :B1 AND ICS.STATUS ='A' AND ICM.IND_COST_CODE = :B2 AND
NVL(ICM.READY_TO_COMPILE_FLAG,'N') ='N')


call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 1 0.00 0.00 0 0 0
0
Execute 782018 274.28 300.56 0 911745 0
0
Fetch 782018 2.10 2.52 0 0 0
0
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 1564037 276.38 303.08 0 911745 0
0

 

 

SELECT 0
FROM
SYS.DUAL WHERE EXISTS ( SELECT 1 FROM PA_IND_COST_MULTIPLIERS ICM ,
PA_IND_COMPILED_SETS ICS WHERE ICM.IND_RATE_SCH_REVISION_ID =
ICS.IND_RATE_SCH_REVISION_ID AND ICM.IND_RATE_SCH_REVISION_ID = :B2 AND
ICM.ORGANIZATION_ID =ICS.ORGANIZATION_ID AND ICM.ORGANIZATION_ID = :B1 AND
NVL(ICM.READY_TO_COMPILE_FLAG,'N') <> 'N' )

 


call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 1 0.00 0.00 0 0 0
0
Execute 782010 188.35 205.05 0 1171182 0
0
Fetch 782010 2.48 2.74 0 0 0
129724
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 1564021 190.83 207.80 0 1171182 0
129724



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