Oracle-L: Re: DBMS

From: <babu.nagarajan_at_Cummins.com>
Date: Tue, 25 Feb 2003 12:35:36 -0800
Message-ID: <F001.005591B4.20030225123536@fatcity.com>

I think since DBMS_STATS also gathers histograms its taking more time

Babu

                                                                                                                                                    
                      Tim Gorman                                                                                                                    
                      <Tim_at_SageLogix.co        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                
                      m>                       cc:                                                                                                  
                      Sent by:                 Subject:  Re: DBMS_STATS                                                                             
                      root_at_fatcity.com                                                                                                              
                                                                                                                                                    
                                                                                                                                                    
                      02/25/03 02:59 PM                                                                                                             
                      Please respond to                                                                                                             
                      ORACLE-L

Could it have to do with the fact that ANALYZE is running against a different partition than DBMS_STATS?

Original Message ----- From: Terrian, Tom (Contractor) (DAASC) To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 25, 2003 11:12 AM Subject: DBMS_STATS

I have never had good luck with DBMS_STATS. It seems that the old analyze runs much faster.....

Runs in 45 seconds:
analyze table log_trans partition (log_trans_20030104) estimate statistics sample 5 percent;

Takes over 2 hours:
execute dbms_stats.gather_table_stats(ownname => 'LDGADMIN', -

                                       tabname => 'LOG_TRANS', -
                                       partname => 'LOG_TRANS_20030102', -
                                       estimate_percent => 5);

Am I missing something? Aren't both commands the same?

Thanks,
Tom

This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: babu.nagarajan_at_Cummins.com

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 Tue Feb 25 2003 - 14:35:36 CST