OBIA 11g Incorrect Stats Generated On Fact Temporary, Reconciliation Tables Used In PLP And Diff Man Loads
(Doc ID 1910835.1)
Last updated on FEBRUARY 22, 2019
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.7.1 and laterInformation in this document applies to any platform.
Symptoms
In BI Application 11.1.1.7.1 the Finalize step which calculates all the stats on Fact, reconciliation and other temporary tables happens at the end of the fact group. So during the incremental loads when you execute the diff man load ETL Task which queries on reconciliation tables and loads the fact tables, the SQL optimizer generates the load plan based on the old stats generated in the last full/incremental load. Because of this the ETL tasks are getting stuck.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |