ASCP Plan Performance Degraded And Memory Based Snapshot Run Time Increased (Doc ID 2012088.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

On Cum Patch level - VCP 12.1.3.9 OR VCP 12.1.3.9.1

PROBLEM
-------------
Run time of the memory based snapshot has increased a lot.

The ASCP plan launch takes more than 3 hours to complete. Usually it completes in 15 minutes. Especially Memory-Based Snapshot, Snapshot Monitor & Snapshot Delete Worker runs for a very long time to complete.

STEPS
--------
Run normal planning cycle

 

Investigation showed:

1. Log file for plan_id = 2 

MSCNSP module: Memory-Based Snapshot
+---------------------------------------------------------------------------+
Current system time is 06-MAY-2015 16:10:09
.......

Lock acquired on MSC_SYSTEM_ITEMS SYSTEM_ITEMS_2
...Updated msc_system_items                                                 19,102   20:23
Delete left queue names for plan 2

***** End Of Program - No title available *****
....
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 06-MAY-2015 18:02:20

2. In file ascp_performance_analyzer_script_output.html from Note 1554183.1
We checked snapshot for plan_id = 2 and find it increased this week from average of 12 mins over last 33 runs to running 164 mins and 112 mins


3. In AWR report -  awrrpt_1_76_78.html for time period when snapshot was running
we see SQL ID -  0c33qy3dv7j7z running long - 4,101.89 seconds

UPDATE MSC_SYSTEM_ITEMS SET ITEM_NAME = :B6 , DESCRIPTION = :B5 , BUYER_NAME = :B4 , PLANNER_CODE = :B3 , PLANNING_EXCEPTION_SET = :B2 , REVISION = :B1 WHERE SR_INSTANCE_ID = :B9 AND INVENTORY_ITEM_ID = :B8 AND ORGANIZATION_ID = :B7 AND PLAN_ID = :B10


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