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

On Dec 7, 11:47 am, nicola.far..._at_info-line.it wrote:
> Patching this database is not an option, at least now (big customer,
> production database and so on)
> But we have other customers with 9206 on the same platform. I'll check
> next week how are their index statistics.
> I did a quick check now but they don't seem to have the same problem.
> They haven't compiled that specific table. They do have
> num_rows=0 etc in the user_indexes statistics but for tables that are
> actually empty (i checked only some. I'd need to write a script to
> check every table/index couple).
> On Metalink I haven't found anything about this, so I don't think
> about a bug here. Certainly I am missing something but .. what ??
>
>
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

Have you checked into the value set for 'compatibility'?

David Fitzjarrell Received on Fri Dec 07 2007 - 12:52:17 CST