SQL>
SQL>
SQL> select
2 Index_Name, /* The name of the index*/
3 Table_Name, /* The name of the table */
4 Monitoring, /* Whether enabled (YES/NO)*/
5 Used, /* Whether index is used (YES/NO)*/
6 Start_Monitoring, /* Timestamp when monitoring began*/
7 End_Monitoring /* Timestamp when monitoring stopped*/
8 from V$OBJECT_USAGE;