Is there an advantage to either of these over "roll your own" (select 'analyze table ' || table_name|| 'compute statistics'....)? (Besides ease of use.)
Since I already have the scripts in place that run the analyze statmement, I'm wondering if it's worth the effort to change the jobs to use dbms_utility.analyze_schema. Thx! Barb > ---------- > From: Connor McDonald[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Wednesday, August 21, 2002 3:58 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: dbms_utility and dbms_stat difference > > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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).
