Autconfig Takes a Very Long Time To Run “adupdlobs.pl”

When running autoconfig during adcfgclone.pl the adupdlobs.pl taken more than 30 min but it not completed. Also please use the below script to validate.

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

If the above sql returns zero then rebuild the index of FND_LOBS.

The script adupdlobs.sql performing full table scan on FND_LOBS

To resolve the issue please do the following:

EXECUTE IMMEDIATE ‘ALTER INDEX applsys.fnd_lobs_ctx REBUILD’;

Then try to rerun the same script manually

$ cd $OAD_TOP/admin/install/$CONTEXT_NAME/
$ sqlplus apps/apps
SQL> @adupdlobs.sql apps apps <SID>

If issues are still there then try to create custom index on fnd_lobs as below

CREATE INDEX applsys.fnd_lobs_cust ON applsys.fnd_lobs (file_name);

Now try again . This time it should complete normal in a minute .

Recent Posts