Re: How can I see when the last time was an index was used?

In article <9q8mhb$njn$1_at_nereid.worldonline.nl>, "Bert says...
>
>Hello,
>
>I have a simple question.
>
>How can I see when the last time was an index was used? Not created or
>changed, but used.
>
>
>Thanks.
>
>Best regards,
>
>Bert Haverkort
>OraTech Group B.V.
>The Nethelands
>
>

You can do this in 9i but not before. In 9i there is a monitor option for indexes to record for you the last time they were USED (as opposed to just accessed to be modified via an insert/update/delete) to execute a query.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp