DBA Hub

📋Steps in this guide1/1

Monitor index usage

---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.

oracle configurationintermediate
by OracleDba
20 views
1

Monitor index usage

--Below query to find the index usage:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
---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;
select * from v$object_usage;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!