ODI Processing Appears to be Stalled - Analytics Performance Overview.
Last updated on OCTOBER 04, 2017
Applies to:Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.
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.
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