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 (Doc ID 2214691.1)

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.

Symptoms

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.

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