Snapshot Delete Worker Performance On MRP_FULL_PEGGING Or Other MRP Plan Tables (Doc ID 361665.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.9 and later
Information in this document applies to any platform.
EXECUTABLE:MRCSDW - Snapshot Delete Worker



*** Checked for relevance on 13-Sep-2013 ***


Symptoms

MRCSDW - Snapshot delete worker is performing poorly when deleting table mrp_full_pegging - the
following excerpt is from the log file:

..Deleted from mrp_full_pegging 75,000 9:46
..Deleted from mrp_full_pegging 75,000 6:34
..Deleted from mrp_full_pegging 75,000 23:53
..Deleted from mrp_full_pegging 75,000 17:02
..Deleted from mrp_full_pegging 75,000 18:15
..Deleted from mrp_full_pegging 75,000 21:15
..Deleted from mrp_full_pegging 75,000 22:00
..Deleted from mrp_full_pegging 75,000 22:18
..Deleted from mrp_full_pegging 75,000 18:40
..Deleted from mrp_full_pegging 75,000 18:18
..Deleted from mrp_full_pegging 75,000 16:24
..Deleted from mrp_full_pegging 75,000 15:01
..Deleted from mrp_full_pegging 75,000 16:42
..Deleted from mrp_full_pegging 75,000 15:26
..Deleted from mrp_full_pegging 75,000 16:31
..Deleted from mrp_full_pegging 53,825 16:20
.10-FEB-2006 06:58:13: executed 32 (32) (TASK=Delete MRP_FULL_PEGGING) 274:26

.
Verified by uploaded log file l5062499_req.txt which shows the details and problem of the
performance issue in mrp_full_pegging for concurrent request MRCSDW

.

Cause

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