oracle 索引监控

oracle 索引监控
打开索引

alter index IDX_INSERTTIME_TLOTMAP monitoring usage；

//必须有一次搜索
select * from tlotmap where inserttime>sysdate-1

 select * from v$object_usage where table_name='TLOTMAP'

关闭
alter index IDX_INSERTTIME_TLOTMAP nomonitoring usage


table flowno