-
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][i]Originally posted by pando [/i]
[B]select 'analyze index '||owner||'.'index_name||' validate structure;'
from dba_indexes
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|