Oatm Migration Is Running Very Long On Fnd_lobs_ctx Index For More Than 35hrs, How to speed Up This OATM Migration Step? (Doc ID 1362261.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Applications Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 07-May-2013***

Goal

This note intends to give advice on this OATM Performance issue.

Frequent questions :

OATM migration is running very long on FND_LOBS_CTX Index for more than 35hrs,
I have made the changes to the temp,undo increased there size already.

There were no invalids in CTXSYS schema, but i am just stuck on that FND_LOB_CTX index. Just let me know how to reduce the rebuild time of that index ?


Solution

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