My Oracle Support Banner

Memory Based Planner Performance Issue MSONWH64 Module (Doc ID 1058694.1)

Last updated on AUGUST 19, 2019

Applies to:

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


On : version, Memory Based Planner

  The MSONWH64 module: Memory Based Planner 64-bit HP, is taking more time in the Test instance, as compared to Production Instance. The same data in Production instance is taking around 80-100 minutes. But in Dev, the same plan is taking close to 5hrs. All the setups are same.

1. Navigate to Responsibility > Advanced Supply Chain Planner.
2. There is a performance issue with Memory based planner.

Current system time is 26-NOV-2009 14:54:02

.Load data completed 1:26
..Selecting Shift times 1,117,46 0:29

DSM om->createAbstEntities(), time taken = 257.617
DSM om->createLinks(), time taken = 257.75
create objects, time taken = 2.25
solve lp 0, take time: 59
gp, time taken = 20.1167
plan 0(1) take time=20.6667
oi, time taken = 20.1833

.Optimization completed 278:22 (SCO)

> Exiting HLS.
..Scheduling completed 36:18 (HLS)

Total Planning Time 321 mins :31 secs --- 5 hrs :21 mins :35 secs
Current system time is 26-NOV-2009 20:15:37

More time is taken by Supply Chain Optimizer.. SCO.. - 278:22
HLS - 36:18

Comparing to Dev instance, the SCO is very much faster here.. HLS has taken almost same time.

The below section in SCO in production is the fastest...
DSM om->createAbstEntities(), time taken = 0.233333
DSM om->createLinks(), time taken = 0.383333

The same section in SCO in Development is the slowest...
DSM om->createAbstEntities(), time taken = 257.617
DSM om->createLinks(), time taken = 257.75

..Updated MSC_SYSTEM_ITEMS 3,648 0:03 (In Production)
..Updated MSC_SYSTEM_ITEMS 3,411 0:03 (In Development)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.