My Oracle Support Banner

30007904 MSCNSPWL64: Memory Based Snapshot 64 Bit Linux Runs Very Long Selecting Substitues (Doc ID 2631042.1)

Last updated on JANUARY 27, 2020

Applies to:

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

Symptoms

12.2.5
MSONWL64.ppc 120.15.12020000.42.1220500.96

We have recently went live with our Manufacturing Orgs
Memory Based Snapshot 64 bit Linux which was earlier taking less than 30 minutes to complete now takes more than 600 minutes
We reviewed the AWR and found this SQL is running for 80% of the time:
SQLID:bt3jr82sbpj9s

Original run time was about 600 mins for 95k rows\
LOG - Memory_Based_Snapshot_64_bit_L_200619_BadPerformance.txt
Time taken to open BOM_CUR 0:55
Selecting BOM                   3,129,756   0:34
Selecting Substitutes             98,219 590:30
Selecting BOD                    519,405     0:04


We implemented a SQL Profile and now we see 300 mins for about 98 k rows
LOG - Memory_Based_Snapshot_64_bit_L_010719.txt
Time taken to open BOM_CUR 1:22
Selecting BOM               3,052,597    0:28
Selecting Substitutes          98,203 305:54
Selecting BOD                394,755      0:10

BUSINESS IMPACT
---------------------------
We are adding new manufacturing organizations to our ASCP plan which will require increased volume of data to be processed by this program.


Cause

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
Symptoms
Cause
Solution
References


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