V$OBJECT_USAGE

You can use this view to monitor index usage. The view displays statistics about index usage gathered from the database. All indexes that have been used at least once can be monitored and displayed in this view.

Column	Datatype	Description
INDEX_NAME	VARCHAR2(30)	The index name in sys.obj$.name
TABLE_NAME	VARCHAR2(30)	The table name in sys.obj$.name
MONITORING	VARCHAR2(3)	YES| NO
USED	VARCHAR2(3)	YES| NO
START_MONITORING	VARCHAR2(19)	The start monitoring time in sys.object_stats.start_monitoring
END_MONITORING	VARCHAR2(19)	The end monitoring time in sys.object_stats.end_monitoring