?
Solved

Index monitoring

Posted on 2012-03-27
4
Medium Priority
?
472 Views
Last Modified: 2012-06-27
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
Comment
Question by:dba1234
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 5

Accepted Solution

by:
Bajwa earned 500 total points
ID: 37771277
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
 
LVL 23

Assisted Solution

by:David
David earned 500 total points
ID: 37771284
Yes but very minor, and worth the effort -- just don't leave it on for the indexes you want to keep.
0
 

Assisted Solution

by:rkkpotty
rkkpotty earned 500 total points
ID: 37772605
Yes it is worthy you can gain storage space too by dropping unused indexes
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 500 total points
ID: 37772859
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question