监控索引使用情况

V$object_usage

1:找出想要监控的列表

select table_name,index_name from user_indexes;

2:监控特定index

alter index indexname morning usage;

3:确定是否使用了索引

select * from v$object_usgae(field used)

4:alter index indexname nomorning usage

select * from v$object_usgae