Re: ANALYZE INDEX...VALIDATE STRUCTURE....

I am not sure but try this:
VALIDATE INDEX <INDEXNAME>

amit
Oracle DBA/Unix SA

Jonathan Waland wrote:

> I'm trying to analyze the fragmentation of an index, and I'm using
> the ANALYZE INDEX ... VALIDATE STRUCTURE command.
>
> Unfortunately on a 4gig index this is proving to be very slow - and
> locks the table for insert/update/delete - not good as we are trickle
> feeding data into it.
>
> Is there any other way that anyone can suggest/recommend for finding
> stats such as HEIGHT, DEL_LF_ROWS, PCT_USED, BTREE_SPACE etc., that is
>
> a) faster
>
> or
>
> b) does not lock the table/index
>
> thanks in advance,
>
> Jon Waland
> Vodafone Ltd.
Received on Wed Feb 04 1998 - 00:00:00 CST