Performance Issue MSONWS64 - Memory Based Planner 64-bit Sun In HLS Slice Stage (Doc ID 2188844.1)

Last updated on SEPTEMBER 01, 2022

Applies to:

Symptoms

On : 12.2.5.1 version, Constrained Planning in Test:

Users are on 12.2.5 and have applied VCP Consolidated update #2 patch 22493520. They are using 64 bit Sun MBP with MSONWS64.ppc 120.26.12020000.19 and no one off patches at this time. Users are running an EDD Classic Constrained plan. However the plan will not complete even after letting it run for 14+ hours. The log file shows the following key findings and where it stops:

MSONWS64 module: Memory Based Planner 64-bit Sun

one in flushing to flatfiles total items 4259
.....Flush Flat Items completed 0:00
done flushing to items flatfiles
.....Create transactions tree completed 0:00
....Load data completed 0:01

....Optimization completed 0:44

pre_reduce_ss is false
......mrprs_pre_reduce_ss completed 0:00
.....Net+Peg+PushDown AllItems completed 7:17

The log got into HLS and here are the last lines

add min effective time -2880 to operation 47048
TIMER: slice 0 phase 2 time = 1882
TIMER: slice 0 phase 2 time = 0
HLSHeuristic2: --------- START OF PHASE 3 -------------
TIMER: slice 0 phase 3 time = 37649
Memory Used: 7875.19 MB; Scheduling duration: 731.416 Mins
====================================================
Slice # 2 (3943 demands) from priority: 999999 to: 999999 ----stops here


EXPECTED BEHAVIOR
-----------------------
Expect the plan run to complete in 2 hours or less

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run EDD Classic Constrained Plan
2. Plan will not complete and is stuck in MBP concurrent request that will not finish even after 14+ hours

Changes

Upgraded from 12.1.3 to 12.2.5

Cause

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