Monitor index usage

oracle, oracle10g, oracle11g, oracle9i

Solution

If the question is : if there are any queries that ever use the index?

ALTER INDEX myindex MONITORING USAGE;

Wait a few days/months/years:

SELECT *
FROM   v$object_usage
WHERE index_name = 'MYINDEX';

http://docs.oracle.com/cd/B28359_01/server.111/b28310/indexes004.htm#i1006905

Problem

Is there a way to find if a a particular Oracle index was ever used by Oracle when executing a query? We have a function based index, which I suspect is not getting used by Oracle and hence some queries are running slow. How could I find out if any query run against the database is using this query?

Original source