RE: dbms_utility and dbms_stat difference

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:hamcdc_at_yahoo.co.uk]
> Reply To: ORACLE-L_at_fatcity.com
> 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 <Chuan.Zhang_at_transact.com.au> 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: hamcdc_at_yahoo.co.uk
>
> 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: ListGuru_at_fatcity.com (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: bbaker_at_denvernewspaperagency.com

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: ListGuru_at_fatcity.com (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).