I launched constrained ASCP plan and it took very long time. I launch ASCP plan in friday and it still not finished yet till monday, Memory Based Shapshot & Snapshot Delete Worker are still running, Loader Worker With Direct Load Option is still in pending phase. MSC: Share Plan Partitions has been set to Yes.
When I run query below :
where table_name like 'MSC_NET_RES_INST%'
OR table_name like 'MSC_SYSTEM_ITEMS%'
order by substr(partition_name,instr(partition_name,'_',-1,1)+1);
The results are:
Please help me how to increase the performance when launching the plan. Is change MSC: Share Plan Partitions to No the only way to increase the performance in running plan?
Thanks & Regards,
a) So does it means that plan was working fine earlier but you are facing this issue recently.. ? If so then what you have changed at server side or have you applied any recent patches.. ?
b) If you have not completed plan for single time,
I will suggest that run data collection in complete refresh mode for one organization which is having relatively small data. Further, you can modify plan options in order to reduce planning calculation load like
- disable pegging
- remove any demand schedule / supply schedule / global forecast etc
- enable only single organization which having relatively small demand and supply picture
- disable forecast spread
Once one plan run will be completed, then expand your collection scope to other organizations and also enabling above mentioned setting.
There are lots of points need to consider for performance issue like server configuration, hardware configuration, num of demands etc. So you can raise SR in parallel while working on above points.