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');

Validate it has been enabled on all indexes (in case some were locked):

select index_name
  from user_indexes
 where index_type not in ('LOB')
minus
select index_name
   from v$object_usage;

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

select *
   from v$object_usage;