Performance Caused by Code of MSC_MANAGE_PLAN_PARTITIONS AND MSC_ANALYSE_TABLES_PK
(Doc ID 2239902.1)
Last updated on JANUARY 17, 2021
Applies to:Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.
Customer has VCP 12.2.5.
Two packages in VCP are causing performance issues for number of seeded and custom programs in VCP (seeded programs are mostly related to ASCP Plan):
Archive Plan Summary
Generate Plan Summary
Loader Worker With Dir
Memory Based Planner 6
Issue identified by DBA who is highly experienced and quite knowledgeable on Oracle RDBMS.
DBA found the root cause of the poor performance is part of code in two packages where he used dbms_stats.auto_sample_size instead of a hard-coded value of 10 for the percent parameter when calling fnd_stats.gather_table_stats.
1. Package: MSC_MANAGE_PLAN_PARTITIONS
The two lines DBA changed in MSC_MANAGE_PLAN_PARTITIONS are lines 1515 and 1520:
(in calls to fnd_stats.gather_table_stats)
percent => dbms_stats.auto_sample_size,degree=>4)
2. Package: MSC_ANALYSE_TABLES_PK
The two lines we changed in MSC_ANALYSE_TABLES_PK are the lines that included a hard-coded value of 10 in the calls to fnd_stats.gather table_stats
Customer needs official patch for the changes.
As manual work-around, they can re-calculate statistics using auto_sample_size.
<Bug 24653389> CODE OF MSC_MANAGE_PLAN_PARTITIONS AND MSC_ANALYSE_TABLES_PK
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