analyze index validate structure script????

Hello
Can anybody send me a script that I can use to analyze all my indexes
at one time instead of doing it one index after the other? e.g
SQL> analyze index SCOTT.ORG_PK validate structure;
Index analyzed.

I want to be able to analyze all the indexs at once not just one at a time.

The same applies to the script below

SQL> select DEL_LF_ROWS*100/decode(LF_ROWS, 0, 1, LF_ROWS) PCT_DELETED,

(LF_ROWS-DISTINCT_KEYS)*100/ decode(LF_ROWS,0,1,LF_ROWS)
DISTINCTIVENESS
from index_stats
where NAME='&index_name';

I don't have a script to do it, but there is a GUI tool that does this called EZSQL (www.ezsql.net, free for 30 days, $100 after that).

Under 'Tuning' there is an option called 'Index Storage'. Select the indexes you want, and click the button with an 'A' on it at the top. It will spool the results to a text file.

-John

select 'analyze index '||owner||'.'index_name||' validate structure;'
from dba_indexes
where owner <> 'SYS';

ORG_PK!!??

Are you working with NASD, perchance?

- Chris

Quote:

---

Originally posted by pando
select 'analyze index '||owner||'.'index_name||' validate structure;'
from dba_indexes
where owner <> 'SYS';

---

Hi does anyone know how to add this dynamic sql code into a pl/sql? And generate a text file?