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;