Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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;