Watch out though! From the 8.1.6
documentation:
"Validating the structure of an object prevents SELECT, INSERT, UPDATE, and
DELETEstatements from concurrently accessing the object. Therefore, do not
use this clause on thetables, clusters, and indexes of your production
applications during
Alex,
This script is based around an analyze index . validate structure as
mentined by Deepak
---
set verify off
set pagesize 35
set linesize 132
set pause on
set pause 'Hit enter to continue'
set feedback off
set showmode off
set echo off
hi @lex
one of the good ways to check this is to do a analyze
index .. validate structure and look at the statistics
from index_stats
Deepak
--- Alexander Ordonez <[EMAIL PROTECTED]> wrote:
> hi gurus, how check the fragmentation on index...??
> ahy idea???
> please i need your help!!
>
> @lex