dbms_stats not getting correct number of num_rows

[jestrada101]

this is put into a loop that gathers stats against partitions...

dbms_stats.gather_table_stats(
ownname => 'ABC',
tabname => 'TABLEA',
partname => prtn_rec.partition_name,
estimate_percent => 0.1,
block_sample => TRUE,
cascade => TRUE);

Any idea why it wouldn't pull the correct num_rows.

In the table, I have approx 8.5 million rows and status 7.3 million...

Thanks for any ideas!

JE

 

[djbjr]

Umm Im not an expert at DBMS STATS PACKAGE, but wouldnt that be because it is estimating .1 percent?

Maybe if you tried estimating 1% or 10%.

I would think if you computed statistics instead of estimating it would have the right row count, can you compute statistics on DBMS STATS?

We are still doing analyzing at our shop for most of our tables.

I heard the analyze will be gone with Oracle 10g, is that true? If so are all of my analyze statements going to fail or will they just do nothing?