My Oracle Support Banner

Improve Performance Of 'Update Standard Costs' CMCICU (Doc ID 750331.1)

Last updated on AUGUST 01, 2018

Applies to:

Oracle Cost Management - Version 12.0.0 and later
Information in this document applies to any platform.
.
***Checked for relevance on 09-FEB-2017***

Symptoms

While 'Update Standard Costs' is running, statistic information is being changed and updated by the below code inside the program all the time.

' begin fnd_stats . gather_table_stats ( :l_schema , 'CST_LISTS_TEMP' ) ;
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'

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.