Autconfig Takes a Very Long Time To Run "adupdlobs.pl" or "adupdlobs.sql"
(Doc ID 404334.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Applications Manager - Version 220.127.116.11 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications Technology Stack - Version 18.104.22.168 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Running Autoconfig takes more than 40 minutes to complete, when it generally finishes in under 10 minutes.
Further investigation shows that the performance problem is being caused by adupdlobs.pl, which calls adupdlobs.sql. This can be seen by running a "tail" on the adconfig.log, to see which scripts run quickly and which ones take significant time. (tail -f adconfig.log)
(The script adupdlobs.sql does full table scan on FND_LOBS. )
The following SELECT returns "0":
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