My Oracle Support Banner

OBIA 11g: Indexes Are In Stale State After ODI Gather Stats Step (Doc ID 2285406.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.8.1 and higher including 11.1.1.10.x

BI Apps modules: - Financials, Proc & Spend, HR Analytics, and custom modules
Target System/Version: DB- Oracle 12C (12.1.0.2.0)

After data loads in OBIA 11G using ODI (and Session finishes successfully), found that the indexes are in stale state.
The ODI gather stats script is using CASCADE=> FALSE due to which it is skipping the stats on indexes and as a result the indexes are becoming stale.

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


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