Index usage monitoring in oracle database
Suppose your index is not being used by SQL query with cost-based optimizer. Index monitoring allow you to easy identify the unused indexes (that are not being used) in oracle database. You can use alter index index_name monitoring command to enable the oracle index usage monitoring. Index usage monitoring Syntax to enable monitoring: – Once you … Read more