dbms_utility is basically a wrapper around a series of ANALYZE commands. Oracle's recommendation is to use DBMS_STATS but do some testing first - I've send instances where dbms_stats runs a lot heavier than analyze
hth connor --- Chuan Zhang <[EMAIL PROTECTED]> wrote: > > Hi, ALL, > > Sorry if this one is posted more than once. > > What is the difference between dbms_utility and > dbms_stats in terms of > statistics gathering? > > Any clues would be much appreciated. > > Chuan > > Unless otherwise stated, this e-mail does not > represent the views of > TransACT Communications Pty Limited. This text and > any attachments of > this e-mail are confidential and may be legally > privileged. This email > is for the use of the intended recipient only. If > you are not the intended > recipient do not take any action in relation to this > email, other than to > notify TransACT Communications by replying to this > e-mail and destroying > the original communication. Except as required by > law, TransACT > Communications does not represent that this > transmission is free of errors, > viruses or interference. > > > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).