VCP 12.2.4.1 Calculate Item Exception phase performance issue in Memory Based Planner 64-bit Linux MSONWL64 (Doc ID 2060311.1)

Last updated on AUGUST 23, 2017

Applies to:

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

Symptoms

In a VCP 12.2.4.1 Instance


ACTUAL BEHAVIOR
--------------

When running an Enforce Capacity Constrained Plan (without detailed scheduling), it's taking a long time calculating exceptions.
The different phases of plan:
Memory Based Snapshot 64 bit Linux - Average time taken= 2 hours
Memory Based Planner 64-bit Linux- Average time taken= 6 hours 20 minutes.

Sub-phases of Memory Based Planner 64-bit Linux:
Optimization Phase(Linear-programming based. Selects alternate sources, processes bills of material and routings, substitute items and components, and alternate resources)= 2 hours 40 minutes average
Exception Phase= 3 hours 15 minutes average

 



call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute  17334     55.91      62.82          0    4983182    1808169     1733357
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    17335     55.91      62.82          0    4983182    1808169     1733357

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 173 
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         0          0          0  UPDATE  MSC_SYSTEM_ITEMS (cr=305 pr=0 pw=0 time=9041 us)
       100        100        100   PARTITION RANGE SINGLE PARTITION: KEY KEY (cr=301 pr=0 pw=0 time=2474 us cost=3 size=53 card=1)
       100        100        100    INDEX RANGE SCAN MSC_SYSTEM_ITEMS_U1 PARTITION: KEY KEY (cr=301 pr=0 pw=0 time=1923 us cost=3 size=53 card=1)(object id 501049)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net more data from client               34668        0.00          0.32
  SQL*Net message to client                   17334        0.00          0.00
  SQL*Net message from client                 17334        0.02          7.15
  log file switch completion                      3        0.01          0.02
  latch: redo allocation                          1        0.00          0.00
  latch free                                      1        0.00          0.00

********************************************************************************


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Advanced Supply Chain Planner > Collections > Oracle Systems > Standard Collections

2. Verify the run times.

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