Query V$OBJECT_USAGE : V_Object_Usage « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. 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;

   
  

Related examples in the same category