After Applying 184.108.40.206.1 - Memory Based Snapshot Performance Is Very Bad
(Doc ID 1673643.1)
Last updated on JUNE 28, 2017
Oracle Advanced Supply Chain Planning - Version 12.1.3 and later Information in this document applies to any platform.
PROBLEM ------------- After applying the 220.127.116.11.1 ASCP RUP - a new issue raises with performance. when plan runs for all planned items, around 13 hours is needed which is really too long. We run gather schema stats for all schema's at 50% and around 8 hours is needed for plan runs.
Request ID Program Name Elapsed Time 7165704 Memory Based Snapshot 64 bit Linux 1,293.48
TKPROF shows problem with
SELECT /*+ ordered */ mscd.demand_id, mscd.inventory_item_id inventory_item_id, mscd.organization_id organization_id, mscd.sr_instance_id sr_instance_id, NVL(sys.product_family_id, -23453), .... AND ((:snapshot_mode = 4 and items.netchange_replan_flag = 1) OR (:snapshot_mode = 1)) ORDER BY USING_ASSEMBLY_DEMAND_DATE,inventory_item_id,organization_id,sr_instance_id