Load Data Warehouse is slow on DWH_X_INV_SUM_FACTS (Oracle)
book
Article ID: 129772
calendar_today
Updated On:
Products
CLARITY PPM FOR ITGCLARITY PPM FEDERALClarity PPM SaaS - ApplicationClarity 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