Many of the decisions to create an index in production are not always rooted in explain plan analysis or from looking at application code. What often happens is hundreds of indexes cluttering up the databases. Two mechanisms within Oracle could help you clean up these unused or performance hogging indexes.

This story continues at
http://www.dbasupport.com/oracle/ora...-Indexes.shtml