Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

On Dec 7, 2:46 am, nicola.far..._at_info-line.it wrote:
> windows 2003 server enterprise edition.
> The table's content isn't changed since yesterday. Statistics were
> gathered at 5 am but index statistics
> are still missing.
>
> I tried importing the table in another instance inside my office (9207
> windows 2000 server)
> but here it is all ok. After gathering statistics I see the expected
> values:
>
> SQL> select s.avg_leaf_blocks_per_key, s.blevel, s.leaf_blocks,
> s.num_rows, s.clustering_factor
> 2 from user_indexes s
> 3 where s.index_name = 'PK_T_DIPARTIMENTI_BUDGET'
> 4 ;
>
> AVG_LEAF_BLOCKS_PER_KEY BLEVEL LEAF_BLOCKS NUM_ROWS CLUSTERING_FACTOR
> ----------------------- ------ ----------- -------- -----------------
> 1 0 1 73 1
>
> Don't know what to think .........
>
>
>
> > Which operating system are you using for this 'troubled' instance?
>
> > David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

I'm thinking that 9.2.0.6 on Windows may be suspect, as 9.2.0.7 on the same platform performs as expected. Have you thought of patching this installation to at least 9.2.0.7, or even 9.2.0.8 to bring it to the terminal release of 9iR2?

David Fitzjarrell Received on Fri Dec 07 2007 - 10:22:53 CST