V$OBJECT_USAGE

Gathers information about indexes in use (alter index ... monitoring).

Columns
___________________________
Record of index usage
INDEX_NAME
Record of index usage
TABLE_NAME
Record of index usage
MONITORING
Record of index usage
USED
Record of index usage
START_MONITORING
Record of index usage
END_MONITORING