Title: 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 takesto
run, and also that sample_size column is always equal to
num_rows.
Would
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 [EMAIL PROTECTED]
wrote: To all 9i DBA's.
I