Seeded Program of AutoReconciliation taking too much time

It was bright sunny day and i was listening to music and performing my UAT cloning when i see a mail from an end user who was complaining about the poor performance of the AutoReconciliation program. 

Since this was a seeded program , yet again i had opened an SR with oracle. 

Oracle asked for multiple traces , logs and tkprofs and finally gave me an action plan, which was to run gss at 100% for certain seeded tables. The AutoReconciliation program took 6-7 hours for an X amount of records. After running the GSS , the program completion time came down to 15 mins for the same X amount of records. 

The steps we followed were :

exec fnd_stats.gather_table_stats('CE','CE_BANK_ACCOUNTS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_BANK_ACCT_USES_ALL',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_CASHFLOWS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_CASHFLOW_ACCT_H',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_PAYMENT_TRANSACTIONS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_SECURITY_PROFILES_GT',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_STATEMENT_RECONCILS_ALL',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_SYSTEM_PARAMETERS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('CE','CE_TRXNS_SUBTYPE_CODES',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('APPLSYS','FND_CURRENCIES',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('APPLSYS','FND_LOOKUP_VALUES',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('GL','GL_DAILY_CONVERSION_TYPES',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('GL','GL_LEDGERS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('AR','HZ_CODE_ASSIGNMENTS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('AR','HZ_CONTACT_POINTS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('AR','HZ_ORGANIZATION_PROFILES',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('AR','HZ_PARTIES',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('AR','HZ_RELATIONSHIPS',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('IBY','IBY_DOCS_PAYABLE_ALL',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('IBY','IBY_PAYMENTS_ALL',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('SYS','TAB$',PERCENT=>100,cascade=>True) ; 
exec fnd_stats.gather_table_stats('XLE','XLE_ENTITY_PROFILES',PERCENT=>100,cascade=>True) ; 

Cheers