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;
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,
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.
select 'analyze index '||owner||'.'index_name||' validate structure;'
where owner <> 'SYS';
Are you working with NASD, perchance?
[QUOTE][i]Originally posted by pando [/i]
[B]select 'analyze index '||owner||'.'index_name||' validate structure;'
where owner <> 'SYS'; [/B][/QUOTE]
Hi does anyone know how to add this dynamic sql code into a pl/sql? And generate a text file?
Click Here to Expand Forum to Full Width