dbms_stats and sample_size

[Scunningham99]

Hi

I am running the following, but not all tables in schema have last_analyzed date the same as the day it was run.
The sample size is not always the same as num_rows, which indicated it has done an extimate.

exec dbms_stats.gather_schema_stats('SUNTERRA', cascade=>true);

The above command should do a compute should it not as estimate_percent is null which means compute in oracle documentation.

database is 8.1.7.3. is this a bug? Is dbms_stats to premature in 8i. As i am aware in 9.2.0.1 the auto caluclate estimate percent does not work properly and is fixed in 9.2.0.4.

any help or pointers would be appreciated!!




Thanks in advance



Sy UK

 

[Scunningham99]

UPDATE:-

i have also tried with the estimate percent option. Oracle states if percent is greater than 50 it does a compute anyway.

exec dbms_stats.gather_schema_stats('SUNTERRA', cascade=>true, estimate_percent=>99);

The above command still yields the same results.

Using analyze table table1 compute statistics works. I reckon that this is a bug issue with dbms_stats being too recent for this release. Anyone else have any input !!!




Sy UK