Monitor index usage - oracle database script

Monitor index usage - Oracle Database Script.

---Index monitoring is required, to find whether indexes are really in use or not. Unused can be dropped to avoid overhead. -- First enable monitoring usage for the indexes.  alter index siebel.S_ASSET_TEST monitoring usage;  --Below query to find the index usage:  select * from v$object_usage;