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;