12.1.3.9.2 Memory Based Planner Taking Over 300 Minutes To Complete (Doc ID 2496333.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Users have upgraded DEV instance from source EBS 12.1.2 on 12.1.3.9.1 with ASCP 12.1.3 on 12.1.3.9.1 to EBS 12.1.3 on 12.1.3.9.2 and ASCP 12.1.3 on 12.1.3.9.2 - using 64 bit Linux MBP version MSONWL64.ppc 120.3.12010000.484.
As part of a troubleshooting effort to reduce the overall run time of the planning cycle, the intent of this SR is to reduce the run time.
This plan is constrained on resources ONLY and is 120 days/0 weeks/0 periods.
There are only 3 orgs out of 16 in this plan. They really need to get all orgs in this plan at some point and skip running the unconstrained plan.
However performance of this plan has never been able to get a good timing.

The log file shows the following key areas:

MSONWL64 module: Memory Based Planner 64-bit Linux

Starts 22-OCT-2018 15:54:20
Ends 22-OCT-2018 22:16:30
Total 6 hr 22 minuts

.Load data completed
10:06
..Net+Peg+PushDown AllItems completed
24:15

> Exiting HLS.
..Scheduling completed
324:59
.Generate data completed
356:58 - 5.5 hours for 3 org plan

Total Planning Time 382:00
Total memory usage: 21567608

They also ran into this issue on 12.1.3.9.1 code line as well

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

STEPS
-----------------------
1. Upgrade from 12.1.3.9.1 to 12.1.3.9.2
2. Run ASCP Cycle
3. Memory based Planner taking 6 hours in hls on its own

Cause

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