Here is the correct link for the article on the index usage in 9i. http://www.oracle.com/oramag/oracle/02-jan/index.html?o12o9index.html
The original post mentioned that the article contained a link to the Metadata package and had a link to it, but it did not contain the link to the article itself !! :( HTH, - Kirti -----Original Message----- Sent: Tuesday, February 05, 2002 10:01 AM To: Multiple recipients of list ORACLE-L Can anyone else get to this article? My browser gets redirected to http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/d_ metada.htm#1656 Jared ��� ����� <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/05/02 12:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: HOW TO KNOW INDEX NOT IN USE? Hello Seema Oracle magazine for 01-02/2002 has on page 91 an article that gives step by step instructions on this issue for 9i. They also have a reference to: http://www.oracle.com/oramag/oracle/jan02/metadata.html Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -----Original Message----- > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > Sent: Mon, February 04, 2002 7:55 PM > To: Multiple recipients of list ORACLE-L > Subject: HOW TO KNOW INDEX NOT IN USE? > > Hi > I there any view which can tell us which indexes are not in use? > Thx > -Seema > > > > _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
