My Oracle Support Banner

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

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
Symptoms
Cause
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.