My Oracle Support Banner

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 JANUARY 30, 2022

Applies to:

Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

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

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
Goal
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.