oracle索引监控

1.查询索引

SELECT  *  FROM SYS.user_indexes;

2.设置索引监控

ALTER INDEX SYS_C008737 MONITORING USAGE;

3.确认是否监控索引

select * from v$object_usage;

4.多次查询表之后关闭监控

ALTER INDEX SYS_C008737 noMONITORING USAGE;

5.确定是否使用了索引

未使用则used字段为no

select * from v$object_usage;

—————————————————————————————————————————————————————
处理多事务引起的空间利用率低效

6.设置索引基线

ANALYZE INDEX SYS_C008737 VALIDATE STRUCTURE;

7.查看空间利用率

select  pct_used from SYS.index_stats where name='SYS_C008737';

8.重构索引

alter INDEX SYS_C008737 REBUILD ONLINE;