Practical Apps DBA

Oracle Apps DBA’s Blog

FND_STATS vs DBMS_STATS

Posted by Navdeep Saini on April 4, 2008

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…

2 Responses to “FND_STATS vs DBMS_STATS”

  1. Puneet Sachar said

    Wonderfull, till now I’m unaware of the facts!!!

    U r the champ buddy!!!

  2. Mohsin said

    Really a very useful info…
    I have been using fnd_stats but the idea behind never clicked .
    now i will ask this while interviewing….

    Great !!!!

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>