Gather Statistics of tables in R12
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