Load Data Warehouse is slow on DWH_X_INV_SUM

Load Data Warehouse is slow on DWH_X_INV_SUM_FACTS (Oracle)

Article Id: 129772

Status: Published

Updated On: 20-03-2019 08:13

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

We are on Clarity version that's lower than 15.5.
When we run the Load Data Warehouse job, it's quite slow. When we check the DWH_GATHER_METRICS_V we see that much of the time taken is for table DWH_X_INV_SUM_FACTS

Environment:

Release: CODFSS99000-15.3-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

DWH_X_INV_SUM_FACTS slowness resolved with S159280 in 15.5.0 and higher