Performance MSCNSP, MSCMON, MSCSDW, MSCNSW Memory Based Snapshot/Workers, Delete Workers, Monitor Hang After RDBMS 11.2.0.3 Upgrade (Doc ID 1403815.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 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

Symptoms


On : 11.5.10.2 version, Memory Based Planner

ACTUAL BEHAVIOR
---------------
After upgrading the database from RDBMS 10.2.0.4 to 11.2.0.3, 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
WHERE
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.

EXPECTED BEHAVIOR
-----------------------
Expect the ASCP plan to complete in less than one hour like it did before the RDBMS upgrade

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from RDBMS 10.2.0.4 to 11.2.0.3
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

Changes

Upgraded from RDBMS 10.2.0.4 to 11.2.0.3

Cause

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 hundreds of Community platforms