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.
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:
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
We are adding new manufacturing organizations to our ASCP plan which will require increased volume of data to be processed by this program.
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