Autconfig Takes a Very Long Time To Run "adupdlobs.pl" or "adupdlobs.sql" (Doc ID 404334.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Applications Manager - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications Technology Stack - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

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

Other Symptoms
The following SELECT returns "0":

SELECT pctversion FROM dba_lobs
WHERE table_name='FND_LOBS'
AND column_name='FILE_DATA';




Cause

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