Performance - EBS (MOSC)

MOSC Banner

Tunning Scripts Take too much time

edited Mar 25, 2012 10:10PM in Performance - EBS (MOSC) 2 commentsAnswered
Hi experts,

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center