adstats.sql after upgrade

Posted by satish on Oct 21, 2022; 2:24am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adstats-sql-after-upgrade-tp11150.html

Dear erman,

Our app version R12.1.3, We have upgraded 11.1.0.7 to 11.2.0.4 in test instance.Upgrade took 4 hours.As a post step,we are running adstats.sql which took almost 7 hours.Since it is run in restricted session,application is not accessible during this time.Any suggestions to reduce the time here.

Thanks,
Satish