Re: RE: DBMS_STATS vs. analyze

From: <rgaffuri_at_cox.net>
Date: Thu, 08 May 2003 11:12:53 -0800
Message-ID: <F001.0059443D.20030508111253@fatcity.com>

dont quite follow the 'gather stale' option. does this mean it only gathers stats on blocks that have changed so its alot faster,, correct?
>
> From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> Date: 2003/05/08 Thu PM 02:47:47 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: DBMS_STATS vs. analyze
>
> dbms_stats
> 1. stats can be gathered in parallel
> 2. stats can be exported/imported
> 3. gather stale option
> 4. gather auto option
>
> analyze
> ???
>
> dbms_stats Vs Analyze 4-0 ...
>
> Raj
> ----------------------------------------------------------------------------
> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
> -----Original Message-----
> Sent: Thursday, May 08, 2003 1:57 PM
> To: Multiple recipients of list ORACLE-L
>
>
> this issue was discussed during the tuning round-table last week ( just to
> keep Paula jealous;)) and at some point someone (Anjo, as far as I remember)
> in the room sad that on some situations the only thing that dbms_stats does
> is - analyze compute ........ . But I guess that besides that you are on the
> right track , it works better
> rgds
>
>
> -----Original Message-----
>
> Sent: Tuesday, May 06, 2003 10:52 AM
> To: Multiple recipients of list ORACLE-L
>
>
> This is an old and probably stupid question, but Im on a new project and
> they are using Analyze. Im trying to get them to switch to DBMS_STATS please
> let me know if my argument is correct. Need to be able to articulate this
> adequately.
>
> 1. DBMS_STATS is faster
> 2. the statistics gathered are better
> 3. you can use histograms and I believe I may have identified some areas
> where they would be appropriate.
>
> anything I missed? Ive pointed them to asktom also. Any other good sources
> to point them to?
>
>
> *********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
>
>

-----Original Message-----
From: MARREIROS,RUI (HP-Portugal,ex1) [mailto:rui.marreiros@hp.com]
Sent: Thursday, May 08, 2003 1:57 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBMS_STATS vs. analyze

this issue was discussed during the tuning round-table last week ( just to keep Paula jealous;)) and at some point someone (Anjo, as far as I remember) in the room sad that on some situations the only thing that dbms_stats does is - analyze compute ........ . But I guess that besides that you are on the right track , it works better

rgds   

-----Original Message-----
From: rgaffuri@cox.net [mailto:rgaffuri@cox.net]
Sent: Tuesday, May 06, 2003 10:52 AM
To: Multiple recipients of list ORACLE-L
Subject: DBMS_STATS vs. analyze

This is an old and probably stupid question, but Im on a new project and they are using Analyze. Im trying to get them to switch to DBMS_STATS please let me know if my argument is correct. Need to be able to articulate this adequately.

1. DBMS_STATS is faster
2. the statistics gathered are better
3. you can use histograms and I believe I may have identified some areas where they would be appropriate.

anything I missed? Ive pointed them to asktom also. Any other good sources to point them to?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu May 08 2003 - 14:12:53 CDT