Using dbms_stats.auto_sample_size in dbms_stats.

2003-12-22 Thread Arnon, Yuval
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

Re: Using dbms_stats.auto_sample_size in dbms_stats.

2003-12-22 Thread Connor McDonald
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