MRCSDW - Snapshot Delete Worker Performance Is Poor
(Doc ID 1580589.1)
Last updated on JUNE 14, 2024
Applies to:
Oracle Materials Requirement Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
On 12.1.3 - Memory Based Planner - In Test
Users used to have very little data in the system. Now they are loading many items, BOM's, organizations etc... They find that MRP plan runs used to run very quickly. However now they're seeing a performance problem in MRCSDW - Snapshot Delete Worker running for over 2 hours. So clearly the performance is poor. In reviewing the log file we found over 900 messages like the following:
..Deleted from mrp_bom_components for org 1969 2,500 0:08
..Deleted from mrp_bom_components for org 1969 2,500 0:09
..Deleted from mrp_bom_components for org 1969 2,500 0:06
..Deleted from mrp_bom_components for org 1969 2,500 0:05
..Deleted from mrp_bom_components for org 1969 2,500 0:09
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:09
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:06
..Deleted from mrp_bom_components for org 1969 2,500 0:09
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:08
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:08
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:06
..Deleted from mrp_bom_components for org 1969 2,500 0:08
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 2,500 0:08
..Deleted from mrp_bom_components for org 1969 2,500 0:07
..Deleted from mrp_bom_components for org 1969 1,417 0:16
.27-AUG-2013 03:56:03: executed 6 (6) (TASK=Delete MRP_BOM_COMPONENTS) 160:03
LOCK TABLE mrp_snapshot_tasks IN EXCLUSIVE MODE
..Locked mrp_snapshot_tasks at 27-AUG-2013 03:56:03 0:00
.27-AUG-2013 03:56:03: fetched -1 (-1) (TASK=-1) 0:00
Total Planning Time 160:03
How is this performance problem resolved?
Solution
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
Goal |
Solution |