MRCSDW - Snapshot Delete Worker Performance Is Poor (Doc ID 1580589.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.3 and later
Information 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, boms, 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

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