Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: index_stats no populating

Re: index_stats no populating

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Fri, 20 Jan 2006 20:12:46 GMT
Message-ID: <2vbAf.39$zh2.18@trnddc01>


fitzjarrell_at_cox.net wrote:
> Comments embedded.
> balvey_at_comcast.net wrote:

>> I'm new to this DBA stuff and I can't seem to get index_stats to
>> populate. I'm running 9.2.0.5 with the compatible parameter set to
>> 8.1.0,  I don't think that should matter though.

>
> Really? Disabling all of the 9i and 9iR2 features in a 9.2.0.5
> database doesn't matter? I would think otherwise.
>
>> I run
>> analyze index [index_name] validate structure;

>
> Which doesn't populate anything.

Really? It does every time I use it. Received on Fri Jan 20 2006 - 14:12:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US