index use rate [message #60009] |
Fri, 09 January 2004 01:50 |
Mat
Messages: 22 Registered: November 2001
|
Junior Member |
|
|
Hi there,
Is there a way to compute the index use rate selecting ad hoc columns from dictionary, rather than using alter index XXX monitoring usage to see if an index is used or not ?
Thanks !
|
|
|
|
Re: index use rate [message #60022 is a reply to message #60009] |
Fri, 09 January 2004 13:38 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
You can try v$segment_Statistics and v$segstat to get the number of logical reads(in proportion to the physical writes which are caused by index maintenance). Those will tell you how much the Index is used , and not just if the Index got used or not which the Monitoring clause tells you.
But do keep in mind that just becos there are a tons of logical reads against an index,doesnt mean that its an efficient index..it tells you how much the index is used.
-Thiru
|
|
|