aprevupd.sql running long
Hi,
We are in the process of upgrading our 11i instance to 12.2.5 and while applying the 12.2 patch we see that aprevupd.sql is running for more than 30 hours. We did run stats on the three tables before starting the upgrade.
exec stats.gather_table_stats('AP','AP_CHRG_ALLOCATIONS_ALL',dbms_stats.auto_sample_size) ;
exec fnd_stats.gather_table_stats('AP','AP_INVOICES_ALL',dbms_stats.auto_sample_size) ;
exec fnd_stats.gather_table_stats('AP','AP_INVOICE_DISTS_ARCH',dbms_stats.auto_sample_size) ;
This sql updates two columns in ap_inv_dists_source.
Thanks in advance