摘要： 本文转自http://space.itpub.net/?uid-22489585-action-viewspace-itemid-729944alterindex&index_name monitoring usage;alter index &index_name nomonitoring usage;select * from v$object_usage where index_name = &index_name;--求数据文件的I/O分布select df.name,phyrds,phywrts,phyblkrd,phyblkwrt,singleblkrds, 阅读全文