tag:blogger.com,1999:blog-1835615957457836695.post793905699336668515..comments2023-03-07T03:01:54.123-06:00Comments on DBA University Blog: Oracle Index Monitoring BenefitsDBA University Bloghttp://www.blogger.com/profile/02732216803583907073noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1835615957457836695.post-16205832028543076212008-08-14T08:38:00.000-05:002008-08-14T08:38:00.000-05:00This was a very good article, thank you for linkin...This was a very good article, thank you for linking me to this in my OTN discussion of the same topic.<BR/><BR/>The one thing I would be very careful about is waiting only 24 hours. I'd check with your user community first before dropping indexes in just 24 hours. We have a lot of monthly and even yearly jobs here that rely on some of these indexes. I'd also create a spot to store the DDL of these dropped indexes so they can be re-created easily if performance issues do crop up. <BR/><BR/>I am actually turning on this monitoring and letting it run for a year before doing anything. I am collecting monthly stats from the v$object_usage table and will do a thorough analysis at year end to compile a list of index candidates to be dropped.<BR/><BR/>-- G. Chaika<BR/>Cornell UniversityAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1835615957457836695.post-47928637359633398302008-03-19T15:21:00.000-05:002008-03-19T15:21:00.000-05:00This article on Index monitoring is very informati...This article on Index monitoring is very informative.<BR/>Thanks<BR/>SaiAnonymousnoreply@blogger.com