Re: Using dbms_stats.auto_sample_size in dbms_stats.

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Mon, 22 Dec 2003 18:04:25 -0800
Message-ID: <F001.005DAA9E.20031222180425@fatcity.com>

There's some notes on my site (www.oracledba.co.uk) about how it goes about its work. Basically, it will do a slightly more work than you might think - throw a 10046 trace on it and you can see how it does its job.

Cheers
Connor

• "Arnon, Yuval" <Yuval.Arnon_at_webloyalty.com> wrote: > To all 9i DBA's.
  >
  > I am trying to find out how efficient (or not ) is
  > the option of running
  > dbms_stats with dbms_stats.auto_sample_size.
  >
  > Reading metalink I see a lot of issues with the time
  > it takes to run,
  > and also that sample_size column is always equal to
  > num_rows.
  >
  > Would like to hear from anyone who is using this in
  > a Production
  > environment,
  >
  > tia
  >
  > Yuval.
  >
  >
  >
  > This transmission may contain information that is
  > privileged, confidential and exempt from disclosure
  > under applicable law. If you, ORACLE-L_at_fatcity.com,
  > are not the intended recipient, you are hereby
  > notified that any disclosure, copying, distribution,
  > or use of the information contained herein
  > (including any reliance thereon) is STRICTLY
  > PROHIBITED. If you received this transmission in
  > error, please immediately contact the sender and
  > destroy the material in its entirety, whether in
  > electronic or hard copy format.
  >
  >
  >
  

  ---

Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"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.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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 Mon Dec 22 2003 - 20:04:25 CST