ODI Processing Appears to be Stalled - Analytics Performance Overview.

(Doc ID 2268169.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Symptoms

If ODI performance is slow or appears not to be progressing or seems stuck on a particular step there are some setup settings that can be checked.  If you decide to stop ODI try to stop it at GATHER_SCHEMA_STATS-DW_STAGE step.  If you stop it there you do not have to run reprocessing.  But if ODI main is stoped somewhere else then you have to run reprocess and you may also need to delete some temp tables.

 

Cause

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