Poor Performance of PLP_RetailPartSeedFact for 'W_RTL_INV_IT_LC_DY_F' and 'W_RTL_INV_IT_LC_WK_A' at End of Month
Last updated on DECEMBER 20, 2016
Applies to:Oracle Retail Merchandising Insights - Version 13.2.4 and later
Information in this document applies to any platform.
Users are experiencing poor performance of PLP_RetailPartSeedFact for W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A at end of month (EOM). The execution time taken by PLP_RetailPartSeedFact is increasing every EOM.
This job inserts all records from W_RTL_INV_IT_LC_G table in new partitions of W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A on EOM. This job takes over four hours to complete and is affecting the availability of RA applications.
Steps to Reproduce:
1. Run PLP_RetailPartSeedFact on EOM.
This job takes 4hrs to complete execution only for W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A table.
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