Index monitoring

I want to on the index usage  monitoring on indexes to drop some of the indexes. there will be any impact on the performance if I set up the monitoring.
dba1234Asked:
Who is Participating?
 
BajwaConnect With a Mentor Commented:
There will be some overhead but typically if you can get rid of substantial indexes due to non-usage it is worth it.   I have noticed a very negligible performance overhead due to index monitoring.
0
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
Yes but very minor, and worth the effort -- just don't leave it on for the indexes you want to keep.
0
 
rkkpottyConnect With a Mentor Commented:
Yes it is worthy you can gain storage space too by dropping unused indexes
0
 
schwertnerConnect With a Mentor Commented:
There are special scripts to find unused indexes.

http://www.dba-oracle.com/oracle_tips_unused_indexes.htm

This is of course not 100% secure, because an index can be used very rarely, but it can be used.

Dropping unused indexes you speed up the DML statements - INSERT, DELETE, UPDATE, MERGE and save also disk space.
0
All Courses

From novice to tech pro — start learning today.