Performance MSCNSP, MSCMON, MSCSDW, MSCNSW Memory Based Snapshot/Workers, Delete Workers, Monitor Hang After RDBMS 188.8.131.52 Upgrade
(Doc ID 1403815.1)
Last updated on JUNE 13, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 184.108.40.206 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Apr-2014 ***
Executable:MSCNSP - Memory-Based Snapshot
ConcurrentProgram:MSCNSW - Memory-Based Snapshot Worker
Executable:MSCSDW - Snapshot Delete Worker
Executable:MSCMON - Snapshot Monitor
On : 220.127.116.11 version, Memory Based Planner
After upgrading the database from RDBMS 10.2.0.4 to 18.104.22.168, users running an Unconstrained ASCP plan notice that the Memory Based Snapshot, Memory Based Snapshot Workers, Snapshot Monitor and Snapshot Delete Worker hangs and will not complete no matter how long they run the plan. This is a performance issue. This did not occur before the RDBMS upgrade. The problem is not with RAC setup, nor number of processes assigned to the concurrent manager. The level 8 trace on MSCNSP Memory Based Snapshot shows the following sql hanging:
UPDATE MSC_SYSTEM_ITEMS SET ITEM_NAME = :B7 , DESCRIPTION = :B6 , BUYER_NAME =
:B5 , PLANNER_CODE = :B4 , PLANNING_EXCEPTION_SET = :B3 , REVISION = :B2 ,
RELEASE_TIME_FENCE_DAYS = :B1
SR_INSTANCE_ID = :B10 AND INVENTORY_ITEM_ID = :B9 AND ORGANIZATION_ID = :B8
AND PLAN_ID = :B11
Gathering schema or table statistics on MSC or MSC_SYSTEM_ITEMS has no effect on the performance.
Expect the ASCP plan to complete in less than one hour like it did before the RDBMS upgrade
The issue can be reproduced at will with the following steps:
1. Upgrade from RDBMS 10.2.0.4 to 22.214.171.124
2. Advanced Supply Chain Planner Responsibility
3. Nav: Supply Chain -> Launch Plan
4. Plan will not complete
5. Plan completed in less than 1 hour prior to RDBMS upgrade
Upgraded from RDBMS 10.2.0.4 to 126.96.36.199
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!