Monitoring the index usage in oracle 11g
776454Jan 14 2011 — edited Mar 12 2013Hi,
We have customer requirement to monitor the Indexes which are not used and redundant.
oracle 11g
Linux platfrom
Sise 2 TB
Number of indexes is 9000 + a
user indexes is 7000+
What would be best way to monitor indexes ?
i assume alter
ALTER INDEX <indx name> MONITORING USAGE;
ALTER INDEX <indx name> NOMONITORING USAGE;
and get the report from v$object_usage is good for one or two but
what would be best method to capture for bulk index usage?
like
to run a statistics with “Oracle index usage monitoring” available in 11g ?
Thanks