OBIA 11g Incorrect Stats Generated On Fact Temporary, Reconciliation Tables Used In PLP And Diff Man Loads
Last updated on FEBRUARY 08, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
In BI Application 18.104.22.168.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.
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