[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

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.
0
dba1234
Asked:
dba1234
4 Solutions
 
BajwaCommented:
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
 
DavidSenior 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
 
rkkpottyCommented:
Yes it is worthy you can gain storage space too by dropping unused indexes
0
 
schwertnerCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now