Re: Performance of DBMS_STATS vs ANALYZE

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Fri, 21 May 2004 15:30:47 +0100 (BST)
Message-ID: <20040521143047.87132.qmail@web25208.mail.ukl.yahoo.com>

Hi Charlotte,

One effective way of speeding up a dbms_stats is to throw a trace on the process and then see what took the longest. More often than not its the big amount of sorting and aggregation that goes on.

Some tweaks to crank up sort_area_size often work some magic !

hth
connor

• Charlotte Hammond <charlottejanehammond_at_yahoo.com> wrote: > Hi Wolfgang,
  >
  > Thanks for that - I think I'll keep the histograms then! :-)
  >
  > Point taken about taking care over if/when to re-gather.
  >
  > Thanks
  > - Charlotte
  >
  >
  

  ---

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

---

                                  

---

Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 21 2004 - 09:27:46 CDT