Message
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@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. [neumann.webloyalty.com]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arnon, Yuval
INET: Yuval.Arnon_at_webloyalty.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 Mon Dec 22 2003 - 10:54:32 CST
