===========================================================
监控索引使用情况
===========================================================
作者: 2jliu(http://2jliu.itpub.net)
发表于: 2007.07.22 11:10
分类: RDBMS
出处: http://2jliu.itpub.net/post/21805/311997
---------------------------------------------------------------
发表于: 2007.07.22 11:10
分类: RDBMS
出处: http://2jliu.itpub.net/post/21805/311997
---------------------------------------------------------------
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
