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
Received on Fri Dec 07 2007 - 11:47:28 CST
