Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Gather Statistics of tables in R12

edited Mar 26, 2015 5:56AM in Core Concurrent Processing - EBS (MOSC) 8 commentsAnswered

Can any help to restore the gather statics of tables in R12

Issue with the Gather Table Statistics in E-Business Suite R12

we have done below steps to improve performance of concurrent program . After performing below steps concurrent program taking more time then previous time (taking one hours extra) to complete.

1. Alter table <table_name> move:

2. Rebuild the index relate to table

3. exec fnd_stats.gather_table_stats ('APPS','GL_LEDGERS',PERCENT=>99);

Below are the table used in concurrent program and steps performs on below tables.

GL_JE_CATEGORIES_TL

GL_JE_SOURCES_TL

GL_PERIODS

GL_PERIOD_STATUSES

GL_LEDGERS

Tagged:

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center