MSRFWOR - Refresh Snapshots Performance Is Poor When Querying MLOG$ Tables
(Doc ID 376471.1)
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.
EXECUTABLE:MSRFWOR - Refresh Collection Snapshots
When running ASCP Planning Data Collections.
A large portion of the overall collection elapsed time (75%) is within the Refresh Collection Snapshots program
1. Run ASCP Planning Data Collections
2. Compare times for programs that are run by checking log files and/OR using Script in <Note 280295.1>
3. Review TKPROF of the trace files for the longer running processes... in this case MSRFWOR - Refresh Collection Snapshots
Verified the issue in the TKPROF of the trace file as noted below:
Note: This could happen with different MLOG$ tables that are accessed during the process.
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