|
-
Hi
In 9i you have something called as v$object_useage..through which you can monitor the index useage to a certain extent..
alter index my_index monitoring useage;
it cant tell us how many times a index has been used or nor hwne it was used..
The used column in v$object_useage will have an yes if the index was used since we turned on monitoring
But read the oracle docs before using it..
regards
Hrishy
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
|