-
Index usage tracking
Hello,
Does someones know an easy way to check if an index is used or not ?
We have lots of indexes, using lots of space but I want to check if all of them are used. There is always the possibility to put the database in trace mode and to analyze traces after but it is quite heavy and time consuming. SO if someone has a better idea .....
Thanks
Anne
-
sure, if you are in 9i you can
-
For more info on 'index monitoring' in 9i, check this link.
http://www.oracle-base.com/Articles/...ncements9i.asp
HTH.
-
This was discussed recently - some ideas in this link for 8i, but no solution as such.
http://www.dbasupport.com/forums/sho...0&pagenumber=1
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
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
|