-
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