Full Load For Endeca Run Graph bom-csttar Performance Issue (Doc ID 1987493.1)

Last updated on MARCH 23, 2016

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Endeca Related Issues


Oracle Cost Management Full load for endeca Run Graph sandbox bom-csttar is running too long.
It is running for over 26 hours as of now and is unacceptable to Business.

Currently Costing Run Graph Full load is Running with smaller Data volume.

Monitoring the run and waiting for it to Complete…
Will verify the Dashboards again, after completion.



Additional checks done -
Researched on what the Costing Run Graph is doing on the Database.
Noticed that, it is doing a non-predicate blind query on CST_END_TXN_REG_FULL_LOAD_V -

SID USERNA TOTALWORK SOFAR UNITS TIME_REMAINING OPNAME TARGET MESSAGE
---------- ------ ---------- ---------- ------ -------------- ----------------- ---------------- ----------------------------------------------------------------------
  1262 APPS 276080 32739 Blocks 32466 Hash Join Hash Join: : 32739 out of 276080 Blocks done


This is a very expensive query on the Database, and explains why this load is taking time.

EXPECTED BEHAVIOR
-----------------------
The performance to be faster


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