Index Monitoring
		
		
		
		Jump to navigation
		Jump to search
		
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;