Improve Performance Of 'Update Standard Costs' CMCICU
(Doc ID 750331.1)
Last updated on JULY 10, 2020
Applies to:Oracle Cost Management - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
While 'Update Standard Costs' is running, statistic information is being changed and updated by the below code inside the program all the time.
fnd_stats . gather_table_stats ( :l_schema , 'CST_ITEM_LIST_TEMP' ) ; END ;'
Run-Time execution plan might be changed according to statistic information of CST_LISTS_TEMP table that is generated during Run-Time. When things come to the worst, the program executes with MERGE JOIN (CARTESIAN) execution plan.
It causes performance issue and slow response time.
Therefore, the customer asks to change the program for the better using, for example, SQL Hint instead of MERGE JOIN (CARTESIAN).
The issue can be reproduced at will with the following steps:
1.Cost Manager responsibility: Run 'Update Standard Costs'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document