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

Query V$OBJECT_USAGE

   <source lang="sql">

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;
  
 </source>