| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_utility and dbms_stat difference
Barbara,
I can't speak for dbms_utility but dbms_stats is supposed to generate statistics at both the partition level and at the table level for partitioned tables, which analyze does not do. These are supposed to be better quality statistics. Be aware that there are bugs related to dbms_stats for partitioned tables at certain levels of 8.1.7.x.
Cherie Machler
Oracle DBA
Gelco Information Network
"Baker, Barbara"
<bbaker_at_denvernewspapera To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
gency.com> cc:
Sent by: Subject: RE: dbms_utility and dbms_stat difference
root_at_fatcity.com
08/21/02 10:13 AM
Please respond to
ORACLE-L
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Cherie_Machler_at_gelco.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).Received on Wed Aug 21 2002 - 11:23:29 CDT
 |
 |