Re: Where are these table stats coming from?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: Barbara Baker <barb.baker@xxxxxxxxx>
- Date: Wed, 08 Jun 2005 11:50:04 -0600
Barbara,
AVG_ROW_LEN = 100 is the default. BLOCKS is gotten out of the segment
header for the table and this is accurate, and I suppose gathering index
statistics requires the number of rows in the table - it is after all
one of the index statistics - so it seems that "compute statistics" on
index builds and rebuilds updates the table stats while it's at it. In
that it behaves consistent with gathering histograms using dbms_stats.
It too update the num_rows table statistics (and perhaps blocks, I
haven't checked that).
What's left to verify is if it will override existing table statistics.
Barbara Baker wrote:
> Wolfgang: Interesting! I should have looked
> Yes, both are filled in. But the value for avg row length is WAY off.
> Should be about 900.
>
> NUM_ROWS : 16233354
> BLOCKS : 3250702
> EMPTY_BLOCKS : 0
> AVG_SPACE : 0
> CHAIN_CNT : 0
> AVG_ROW_LEN : 100
> AVG_SPACE_FREELIST_BLOCKS : 0
--
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
