Memory Based Planner 64-Bit Linux Takes Longer Time Than Memory Based Planner(32-Bit) Takes Time on Same Data Set (Doc ID 2589335.1)

Last updated on SEPTEMBER 17, 2019

Applies to:

Symptoms

Actual Behavior
Memory Based Planner 64-bit Linux takes longer time than Memory Based Planner(32-bit) takes time on same data set.

The log file shows the performance is bad in Scheduling phase.
64-bit
-------
..Scheduling completed                                                    
45:43
.Generate data completed                                                  
50:57

32-bit
-----------
..Scheduling completed                                                    
13:09
.Generate data completed                                                  
18:22

Seems 64-bit MBP takes more time and consumes more memory per 1 slice.
64-bit
-----------
Slice # 1115 (100 demands) from priority: 999999 to: 999999
TIMER: slice 1114 pre phase 1 time = 0
All Operation = 100
TIMER: slice 1114 phase 1 time = 0
TIMER: slice 1114 phase 2 time = 0
TIMER: slice 1114 phase 2 time = 0
TIMER: slice 1114 phase 3 time = 0
Memory Used: 4.96587 MB; Scheduling duration: 0.00966667 Mins
32-bit
-----------
Slice # 1115 (100 demands) from priority: 999999 to: 999999
TIMER: slice 1114 pre phase 1 time = 0
All Operation = 100
TIMER: slice 1114 phase 1 time = 0
TIMER: slice 1114 phase 2 time = 0
TIMER: slice 1114 phase 2 time = 0
TIMER: slice 1114 phase 3 time = 0
Memory Used: 2.71307 MB; Scheduling duration: 0.00616667 Mins

Expected Behavior
Memory Based Planner 64-bit Linux take not so longer time than Memory Based Planner(32-bit) takes time on same data set.

Steps to Reproduce

1. Set profile MSC: 64-bit Planner Platform to Linux 64-bit
2. Run the constrained plan.

Changes

Cause

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