Autconfig Takes a Very Long Time To Run "adupdlobs.pl" or "adupdlobs.sql"
Last updated on OCTOBER 06, 2016
Applies to:Oracle Applications Manager - Version 18.104.22.168 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications Technology Stack - Version 22.214.171.124 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":
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms