Oracle

DBA / Tuning

Index monitoring

Enable monitoring:

select 'alter index ' || owner || '.' || index_name || ' monitoring usage;'
  from dba_indexes
 where owner = '?'
   and index_type not in ('LOB');

Verify, make sure to connect as the owner of the objects you are monitoring:

select *
   from v$object_usage;