Memory Based Snapshot Performance Issue (Doc ID 1999908.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Planner workbench

ACTUAL BEHAVIOR
---------------
Memory Based Snapshot Performance Issue

Currently in Production we are running Complete refresh Data Collection and 2 ASCP plans .One for asia pacific region and other for Europe region. Memory Based Snapshot( Memory Based Snapshot 64 bit Linux ) which is running for our Asia Pacific Plan is taking 80 mins to complete .

We want to reduce the run time for this Memory based Snapshot run so that our request for our regional plans will complete in time.

Currently as per schedule plan for Asia Pacific is starting around 11 pm GMT and the memory based snapshot is taking 80 mins during this schedule run.

We have tried running our back up plan in different time other (05 am GMT) and during that run Memory based Snapshot completed in 18 mins.

Our phase 2 go live is pending because of this performance issue and we really need a Urgent solution to reduce the run time of Memory Based Snapshot.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Launch Plan



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