These might help:
1. Edit the resulting file validate_index_ims.sql
set heading off
set pagesize 49999
set width 160
spool validate_index_ims.sql
select 'VALIDATE INDEX '||OWNER||'.'||INDEX_NAME||';',
'INSERT INTO MY_INDEX_STATISTICS(SELECT * FROM INDEX_STATS);'
from dba_indexes
where owner <> 'SYS'
and owner <> 'SYSTEM';
spool off
2. Run the edited validate_index_ims.sql
3. Run this script to get an idea about the fragmentation:
select name,
used_space,
del_lf_rows,
lf_rows,
round(del_lf_rows/(lf_rows+0.000000001))*100 "Frag Percent"
from index_stats;
HTH
David Knight
OCP DBA 8i, 9i, 10g