Sunday, October 4, 2009

FND_STATS vs DBMS_STATS

FND_STATS vs DBMS_STATS

I have been asked this questions many times. Shoud we use fnd_stats or should we use dbms_stats in 11i (or release 12). Most of the Apps DBAs you will face will say use fnd_stats. In fact Oracle also recommends to use fnd_stats in 11i E-Business Environments. But do you know what are the basic difference or you can say advantages or using FND_STATS over DBMS_STATS.
Here I have tried to compare the two…

1 comment:

Anonymous said...

feel free repairing corrupted files of specified format with the repair table sql program