OBIA 11g: Indexes Are In Stale State After ODI Gather Stats Step
Last updated on AUGUST 07, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
OBIA 220.127.116.11.8 and higher including 18.104.22.168.x
BI Apps modules: - Financials, Proc & Spend, HR Analytics, and custom modules
Target System/Version: DB- Oracle 12C (22.214.171.124.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.
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