Load Data Warehouse is slow on DWH_X_INV_SUM_FACTS (Oracle)
Article ID: 129772
Updated On:
Products
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS
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
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:
Component:
Resolution
DWH_X_INV_SUM_FACTS slowness resolved with S159280 in 15.5.0 and higher
Feedback
Yes
No
Powered by
