Oracle PL/SQL/System Tables Views/V Object Usage

Query V$OBJECT_USAGE

 
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;