Index Monitoring
Too many indexes may not be a good thing … Oracle engine keeps all indexes defined on a table independently of their use. Their maintenance can cause considerable use of CPU and I/O which can be heavy to system performance in a high-intensity writing . Periodically can be useful to identify and remove indexes that are not used. Monitoring of the indices allows us to make a precise analysis. It is important to ensure that the index monitoring is carried out for a representative period of time (es. entire life cycle of your application). Index monitoring is started and stopped...