Expanding Pegging Tree Is Slow (Doc ID 1601522.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

12.1.3.6 - Pegging Performance

Customer recently upgraded from 11i to 12.1.3.6.
In 11i, expanding the pegging tree took 1 to 3 seconds. In the 12.1.3.6 instance, it now takes 20 seconds for some levels.

- The performance is bad no matter what order types, orgs, items.....
- The performance has been poor since go-live
- The APPS schema was recompiled using ADADMIN - no improvement. We run Gather Schema Stats for MSC schema after the plan finishes with no improvements.
- Support suggested the following:

Run Gather table statistics for the following tables
owner - MSC
table
msc_system_items
msc_full_pegging
msc_supplies
msc_demands

with parameters
Estimate percent - 50
Granularity - ALL
others at default

- Set pga_aggregate_target to 20G (per note 975933.1)
- Verified profile 'MSC:Launch Analyze Plan Partition' to 'Yes'(per note 975933.1)

The initial expansion of the pegging tree goes from 56 seconds into the video to 1:16. That is 20 seconds.
Then for pegging to the sales order it goes from 1:24 - 1:43 = 19 seconds.
Support would like to know what else we can suggest and what kind of logging is needed to further troubleshoot.

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