Tunning Scripts Take too much time
We run on daily basis scripts which analyze multiple table of oracle ebs 11i oracle 10g and we also have execute schema statistics,
Issue is this it take too much time to complete some time more than 12 hrs. It looks like hang on gathereing statistics Inv and ont schema.
Kindly give me solution
e.g
analyze table inv.mtl_transaction_types compute statistics;
analyze table wip.wip_schedule_groups compute statistics;
analyze table WSH.WSH_DELIVERY_DETAILS compute statistics;
exec DBMS_STATS.GATHER_SCHEMA_STATS('APPS'); ---APPS, APPLSYS, INV,ONT,WSH, SYS, SYSTEM, GL,HR,AR,AP,CE,WIP,