My Oracle Support Banner

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 and later
Information in this document applies to any platform.


In BI Application 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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.