www.ixora.com.au there is a script in there that will identify unnecessary redundant indexes.
for the record, that is one of the best oracle websites out there. Lots of great stuff on it. > > From: Branimir Petrovic <[EMAIL PROTECTED]> > Date: 2004/01/21 Wed AM 10:39:25 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Healty ratio of index segment size vs table segment size? > > Wondering if there is a "rule of thumb", quick'n fast but good enough > to be used as an indicator, litmus paper so to speak, of overly indexed > table(s)... > > Can, better yet - should, sheer size comparison of index versus table > segments be used as a reliable pointer to problematic table indexing? > > If it can, what could be considered as average "healthy ratio" above > which would be prudent to have a closer look and investigate? > > Related to the above dilemma, how "expensive" is to monitor index usage, > say if script is run against all few hundred indexes on app tables, > would the additional load noticeably affect application performance or > is it better/safer or may be required to monitor not more than just a > few "most suspected" indexes at a time? > > Thoughts, pointers, opinions - appreciated. > > Branimir > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Branimir Petrovic > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).