I think since DBMS_STATS also gathers histograms its taking more time
Babu
Tim Gorman
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
m> cc:
Sent by: Subject: Re: DBMS_STATS
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [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).
