The article is in: http://www.oracle.com/oramag/oracle/02-jan/index.html?o12o9index.html
The link in the article is a link to doc that describe the the DBMS_METADATA package. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tue, February 05, 2002 5:59 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: HOW TO KNOW INDEX NOT IN USE? > > 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 > > > > > > &alef;&dalet;&resh; &yod;&het;&yod;&alef;&lamed; <[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 > > > > > > > > _________________________________________________________________ > > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Seema Singh > > 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). > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > This e-mail was scanned by the eSafe Mail Gateway > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= > 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). > > > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?&alef;&dalet;&resh;_&yod;&het;&yod;&alef;&lamed;? 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).
